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" [图片] 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;"'

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.

[图片] 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

badr (Badr) 2015 年11 月 14 日 19:16 5

THANKS!

This is exactly what I was looking for…

话题		回复	浏览量
Does the Discourse install set a default postgres password? Self-hosting	3	1922	2024 年5 月 26 日
PostgreSQL Details Self-hosting	13	1970	2022 年5 月 18 日
How to access the discourse database? Self-hosting	13	17610	2022 年3 月 10 日
Postgresql credentials Self-hosting	2	492	2023 年10 月 3 日
Accessing Database while discourse not running Development	0	174	2025 年4 月 19 日

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

相关话题