tmm1
(Aman Gupta)
September 29, 2018, 6:02pm
1
README states 9.3+ is required. But using 9.4.18 I am seeing errors in Jobs::UpdateUsername
PG::UndefinedFunction: ERROR: function jsonb_build_object(unknown, text, unknown, text, unknown, text, unknown, text) does not exist
LINE 4: jsonb_build_object(
It appears that jsonb_build_object was added in 9.5
2 Likes
pfaffman
(Jay Pfaffman)
September 29, 2018, 6:26pm
2
Standard install:
# psql --version
psql (PostgreSQL) 10.3 (Ubuntu 10.3-1.pgdg16.04+1
That’s what I’d recommend. You can search here, but I think 10 is required.
2 Likes
@rishabh can you update readme as you have time.
2 Likes
rishabh
September 30, 2018, 12:31pm
5
I’ve updated README.md
and a few other docs, Thanks @tmm1
I’ve just bumped it from 9.3 to 9.5 for now because Ubuntu 16.04 still ships with 9.5
3 Likes
Falco
(Falco)
September 30, 2018, 1:17pm
6
We should really point to 10, since it’s what we use on every install.
PostgreSQL officially supports Ubuntu 16.04: Apt - PostgreSQL wiki
6 Likes
rishabh
September 30, 2018, 3:05pm
7
Sure, I’ll change it back to 10!
I chose 9.5 because on a fresh 16.04 droplet:
apt install postgres
→ installs 9.5
apt install postgres-10
→ doesn’t have an installation candidate
so our instructions here will not work on 16.04:
https://github.com/discourse/discourse/blob/master/docs/DEVELOPER-ADVANCED.md#preparing-a-fresh-ubuntu-install
Can I update that guide to say Postgres 10 & Ubuntu 18.04?
2 Likes
Falco
(Falco)
September 30, 2018, 3:32pm
8
Yes, the guide should point to the official PostgreSQL docs for installation, so it will work in any distro/version.
6 Likes