Hello, 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) ho…

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

[image] codinghorror: Unfortunately I don’t think it will be possible to install Discourse without super user account in Postgres. 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 pr…

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

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

Do we have to modify the web.template.yml file? In particular this part: env: # You can have redis on a different box RAILS_ENV: 'production' UNICORN_WORKERS: 3 UNICORN_SIDEKIQS: 1 # this gives us very good cache coverage, 96 -> 99 # in practice it is 1-2% perf improvement RUBY_GLOBA…

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

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.

Install the docker version with a remote postgresql

Support Self-hosting

mpalmer (Matt Palmer) June 23, 2016, 11:48pm 4

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

Topic		Replies	Views
Configure Discourse to use a separate PostgreSQL server Self-Hosting how-to	50	28869	January 8, 2026
pgSQL root access - without? (docker) Self-hosting	3	838	April 14, 2021
Can I install Discourse with my own Redis and Postgres? Self-hosting	5	2165	February 3, 2021
Discourse Database Question/Support Self-hosting	4	843	February 15, 2021
Installation Help required Self-hosting	8	2310	July 30, 2018

Install the docker version with a remote postgresql

Related topics