Install the docker version with a remote postgresql

(Bertrand Bellenot) #1


We are migrating our phpbb3 forum to discourse (yeah!)
So I’m trying to install (configure) a standard discourse (docker version) with a remote postgresql server (centrally provided by IT, for which I don’t have superuser permission)
Is there a simple explanation (or a concrete example) how to do it?
Thanks in advance!

Cheers, Bertrand.

(Jeff Atwood) #2

Unfortunately I don’t think it will be possible to install Discourse without super user account in Postgres.

(Matt Palmer) #3

Hmm, I dunno… the only thing you should need superuser for is to create the DB and role; from there, the regular user can do everything. So if Central IT (all praise the glorious Leader!) do those bits, and the config in app.yml is setup with the correct creds, surely it’d work OK?

/me gives it a go

OK, that worked well enough (for the most part). I’ll write up a howto topic and link it from here, since there are a few steps to making it work right.

(Matt Palmer) #4

Give this new, shiny howto a go, and post in that topic if you’ve got any problems.

(Bertrand Bellenot) #5

Thank you very much everybody, I will give it a try and let you know.

Cheers, Bertrand.

(Bertrand Bellenot) #6

Hi Matt,

It seems to work! Thank you very much! :grinning:
I’ll post again if something goes wrong with the DB…

Cheers, Bertrand.

(Bertrand Bellenot) #7

Do we have to modify the web.template.yml file?
In particular this part:

  # You can have redis on a different box
  RAILS_ENV: 'production'
  # this gives us very good cache coverage, 96 -> 99
  # in practice it is 1-2% perf improvement
  # stop heap doubling in size so aggressively, this conserves memory

  DISCOURSE_DB_SOCKET: /var/run/postgresql

Shouldn’t this also point to our remote postgresql instance?
(same question for any other configuration file…)

(Sam Saffron) #8

Not really , everything in ‘app.yml’ overrides the templates it mixes in

(Bertrand Bellenot) #9

OK, thanks! And BTW, I really love Discourse! :slight_smile:
Thanks to your help, we finally migrated from our phpBB forum to Discourse (today) :slight_smile:

Cheers, Bertrand.