How to access the discourse database?

sam · Janvier 17, 2017, 2:59

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…

Sujet		Réponses	Vues
How can I use GUI to access the postgresql db in docker Installation	1	534	Août 4, 2023
Accessing Database while discourse not running Dev	0	51	Avril 19, 2025
Is it possible to login into the postgres database inside the docker image? Installation	6	4596	Janvier 26, 2023
Does the Discourse install set a default postgres password? Installation	3	1780	Mai 26, 2024
discourse容器部署方式下，如何在外部连接到数据库，例如使用DBeaver连接 Support	2	80	Mai 28, 2025

How to access the discourse database?

Sujets connexes