The discussion revolves around accessing the PostgreSQL database used by Discourse within a Docker container. badr seeks the username and password for the PostgreSQL DB and asks if changing the password will affect Discourse. watchmanmonitor suggests creating a new service account, but badr notes that access is needed first. tgxworld provides the command to access the database: ./launcher enter app followed by su postgres -c "psql discourse", referencing the default template for credentials. badr confirms this resolves the issue. codinghorror adds useful PostgreSQL commands for database exploration, such as listing databases (\l), selecting a database (\c dbname), and querying tables. Later, codinghorror notes that the command may fail if the container isn’t running, requiring ./launcher start app to resolve the issue.
Hello,
I need to integrate a product on my discourse by adding some tables to the discourse db in postgres. Where can I find the username and password for the PostGres DB Discourse is using.
I also wanted to ask if I change the postgres password like its suggested here:
./launcher enter app
su - postgres
psql
ALTER ROLE postgres WITH PASSWORD 'your-new-password';
will that break discourse or will discourse work with that new password…
Any reason not to make yourself a new service account w different name & password?
Because in order to do that I need to log into Postgres and I don’t know the account information Discourse uses for that.
If you’re following the standard Docker install and did not change the postgres template, try
./launcher enter app
su postgres -c "psql discourse"
THANKS!
This is exactly what I was looking for…
Amplifying on this, some basic postgres commands once you have the postgres command line in the container:
list all databases
\l
select a database
\c dbname
list tables in the current database
\dt
list columns in the users table
\d+ users
number of rows in the users table
select count(*) from users;
display value of configuration variables
show shared_buffers;
exit from the postgres console
\q
If you know SQL I am sure you can take it from here 
note that all SQL must terminate with semicolon ;
Abbiamo istruzioni aggiornate qui? Quando provo ora ottengo
root@endoffice-b:/var/discourse# su postgres -c "psql discourse"
No passwd entry for user 'postgres'
ah aspetta, il riavvio ha aiutato e questo ha funzionato:
root@endoffice-b:/var/discourse# ./launcher enter app
x86_64 arch detected.
WARNING: containers/app.yml file is world-readable. You can secure this file by running: chmod o-rwx containers/app.yml
root@endoffice-b-app:/var/www/discourse# su postgres -c 'psql discourse'
psql (13.7 (Debian 13.7-1.pgdg110+1))
Type "help" for help.
Fondamentalmente dovevo avviare il container Docker:
./launcher start app