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 user…

Take a look at this Topic, it gives you the series of commands you need about half way down: [صورة] PostgreSQL 13 update announcements 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 w…

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 | | {} post…

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

الدعم تثبيت

merefield (Robert) 17 مايو 2022، 8:26م 2

ألق نظرة على هذا الموضوع، فهو يعطيك سلسلة الأوامر التي تحتاجها في منتصف الطريق تقريبًا:

الموضوع		الردود	مرات العرض
Is it possible to login into the postgres database inside the docker image? Self-hosting	6	4656	26 يناير 2023
Does the Discourse install set a default postgres password? Self-hosting	3	1836	26 مايو 2024
How to access the discourse database? Self-hosting	13	17177	10 مارس 2022
Postgresql credentials Self-hosting	2	460	3 أكتوبر 2023
Accessing Discourse DB with DBeaver Community Building	0	67	25 أبريل 2026

تفاصيل PostgreSQL

الموضوعات ذات الصلة