How to access the discourse database?

sam · Janeiro 17, 2017, 2:59pm

postgres runs under the postgres user, per:

discourse/discourse_docker/blob/master/templates/postgres.template.yml#L40


      
          - exec: chown postgres:postgres /shared/postgres_run/13-main.pg_stat_tmp
          - file:
             path: /etc/service/postgres/run
             chmod: "+x"
             contents: |
                #!/bin/sh
                exec 2>&1
                HOME=/var/lib/postgresql USER=postgres exec thpoff chpst -u postgres:postgres:ssl-cert -U postgres:postgres:ssl-cert /usr/lib/postgresql/13/bin/postmaster -D /etc/postgresql/13/main
          
          - file:
             path: /etc/service/postgres/log/run
             chmod: "+x"
             contents: |
               #!/bin/sh
               mkdir -p /var/log/postgres
               exec svlogd /var/log/postgres
          
          - file:
             path: /etc/runit/3.d/99-postgres
             chmod: "+x"
             contents: |

You want to sudo postgres psql discourse to hit the right user and database…

Tópico		Respostas	Visualizações
How can I use GUI to access the postgresql db in docker Installation	1	534	4 de Agosto de 2023
Accessing Database while discourse not running Dev	0	51	19 de Abril de 2025
Is it possible to login into the postgres database inside the docker image? Installation	6	4596	26 de Janeiro de 2023
Does the Discourse install set a default postgres password? Installation	3	1780	26 de Maio de 2024
discourse容器部署方式下，如何在外部连接到数据库，例如使用DBeaver连接 Support	2	80	28 de Maio de 2025

How to access the discourse database?

Tópicos relacionados