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