Hey, I was wondering how do you access Postgresql details? Like where would I see the pw and the user for instance? I know the rest of course.

We configure the database to trust and allow connections from the same IP without a password, so there isn’t a password for you to find. If you have a standard Discourse install, you will need to: change the app.yml configuration to expose the 5432 port to the external world create a new username/password pair that has read access to the tables you want

Take a look at this Topic, it gives you the series of commands you need about half way down: [image] PostgreSQL 13 update megaphoneAnnouncements warning WARNING! If your database is very large, you will need a lot of extra disk space (2x database size) and should be very careful with this upgrade! We’ve just landed changes to upgrade our Docker image to PostgreSQL 13. Any site admins rebuilding Discourse from the command line will be upgraded to PostgreSQL 13 from the previous PostgreSQL 12. Note that if you held back from upgrading when the PostgreSQL 12 update happened back in May, you can skip that upgrade and go straight to P…

I didn’t expect it to be this of a big deal to just get password and username lol

Assuming you have a standard Discourse docker installation, you can connect to the postgres database with the postgres user. No password needed: cd /var/discourse ./launcher enter app su postgres psql \c discourse If you want to list all users you can run \du

I wished to access from a desktop app like DBeaver, which is why I was curious. Obviously I don’t want to force change the user password as it would break the community.

Never used DBeaver before but I think it should work with an empty password Connection without password is not supported · Issue #6269 · dbeaver/dbeaver · GitHub

Hmm, that might work but I also received “FATAL: password authentication failed for user “discourse””

Try with postgres as the username.

List of roles Role name | Attributes | Member of -----------+------------------------------------------------------------+----------- discourse | | {} postgres | Superuser, Create role, Create DB, Replication, Bypass RLS | {} It must be discourse, but then it should be something with the authentication.

Yeah, the port expose was clear in the first place. Uhm, I have no idea why I didn’t think of the new user lol, that worked. Thx

Consider the data explorer plugin, much less hassle!

PostgreSQL Details

Product Support Self-hosting

Marcell_Csendes (Marcell Csendes) May 18, 2022, 9:18am 13

I see your idea, the reason I went with DBeaver, is because I deal with more databases beside of Discourse’s, so that’s why decided to do this way.

Topic		Replies	Views
Is it possible to login into the postgres database inside the docker image? Self-hosting	6	4747	January 26, 2023
Does the Discourse install set a default postgres password? Self-hosting	3	1924	May 26, 2024
How to access the discourse database? Self-hosting	13	17621	March 10, 2022
Postgresql credentials Self-hosting	2	492	October 3, 2023
Accessing Discourse DB with DBeaver Community Building	0	158	April 25, 2026

PostgreSQL Details

Related topics