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…

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" [image] badr: Where can I find the username and password for the PostGres DB Discourse is using. templates/postgres.template.yml 8bd5ef16b - exec: su postgres -c 'createdb $db_name' || true - exec: su postgres -c 'psql $db_name -c "create user $db_user;"' || true - exec: su postgres -c 'psql $db_name -c "grant all privileges on database $db_name to $db_user;"' || true - exec: su postgres -c 'psql $db_name -c "alter schema public owner to $db_user;"' - exec: su postgres -c 'psql template1 -c "create extension if not exists hstore;"' - exec: su postgres -c 'psql template1 -c "create extension if not exists pg_trgm;"' - exec: su postgres -c 'psql $db_name -c "create extension if not exists hstore;"' - exec: su postgres -c 'psql $db_name -c "create extension if not exists pg_trgm;"'

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 :wink: note that all SQL must terminate with semicolon ; Also, some queries to identify largest tables.

[image] Alan Tan: ./launcher enter app su postgres -c "psql discourse" Do we have updated instructions here? When I try that now I get root@endoffice-b:/var/discourse# su postgres -c "psql discourse" No passwd entry for user 'postgres' ah wait, rebooting helped and this worked: 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. Basically I needed to start the Docker container: ./launcher start app

Is it possible to login into the postgres database inside the docker image?

Product Support Self-hosting

watchmanmonitor (Allen Hancock) November 2, 2015, 1:43am 2

Any reason not to make yourself a new service account w different name & password?

Topic		Replies	Views
Does the Discourse install set a default postgres password? Self-hosting	3	1924	May 26, 2024
PostgreSQL Details Self-hosting	13	1978	May 18, 2022
How to access the discourse database? Self-hosting	13	17619	March 10, 2022
Postgresql credentials Self-hosting	2	492	October 3, 2023
Accessing Database while discourse not running Development	0	175	April 19, 2025

Is it possible to login into the postgres database inside the docker image?

Related topics