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

tgxworld · 2015 年11 月 2 日 08:04

If you’re following the standard Docker install and did not change the postgres template, try

./launcher enter app
su postgres -c "psql discourse"

github.com/discourse/discourse_docker

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;"'

话题		回复	浏览量
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?

相关话题