Hi, I’m trying to get into the Discourse PostgreSQL database to learn how it’s laid out so I can do some tweaks to the import script to meet my specific needs. Only problem is that I can’t get into psql in the docker. When I run: psql root -h localhost I am asked for a password. I’ve tried just h…

[image] 007: Only problem is that I can’t get into psql in the docker. When I run: psql root -h localhost I am asked for a password. Try su postgres psql

Thanks! That worked. I also dug into Data Explorer a little more and realized I could build my queries from that and didn’t even need direct db access. Helpful to know though.

I had the same question. Is there a password, if so, where is this in the configuration? Is it safe to change the psql user password (e.g. password rotation) and where should the corresponding password be updated in the config? If running python scripts against a database, it would be helpful to u…

Does the Discourse install set a default postgres password?

Support Self-hosting

Falco (Falco) April 11, 2020, 7:45pm 2

Try

su postgres
psql

Topic		Replies	Views
Is it possible to login into the postgres database inside the docker image? Self-hosting	6	4715	January 26, 2023
How to access the discourse database? Self-hosting	13	17466	March 10, 2022
How to get a password from database? Self-hosting	7	1547	May 29, 2023
PostgreSQL Details Self-hosting	13	1852	May 18, 2022
pgSQL root access - without? (docker) Self-hosting	3	928	April 14, 2021

Does the Discourse install set a default postgres password?

Related topics