Documentation request: Overview about database access and configuration in a development environment.

thoka · March 20, 2023, 9:45am

In the context of understanding how to restore a backup in a freshly installed development environment (docker) I would be happy about some explanation, how the database is set up and the connection to the database is configured:

thoka · March 20, 2023, 10:53am

Database configuration is done here:

github.com

discourse/discourse_docker/blob/990519e2373ec32055a7742a407e81f4bd606ed4/image/discourse_dev/Dockerfile#L27-L40


      
          # get postgres going
          ADD postgres.template.yml /pups/postgres.yml
          RUN LANG=en_US.UTF-8 /pups/bin/pups /pups/postgres.yml
          
          
# add dev databases
          ADD postgres_dev.template.yml /pups/postgres_dev.yml
          RUN /pups/bin/pups /pups/postgres_dev.yml
          
          
# move default postgres_data out of the way
          RUN mv /shared/postgres_data /shared/postgres_data_orig
          
          
# re-instantiate data on boot if needed (this will allow it to persist across
          # invocations when used with a mounted volume)
          ADD ensure-database /etc/runit/1.d/ensure-database

Create development databases:

github.com

discourse/discourse_docker/blob/990519e2373ec32055a7742a407e81f4bd606ed4/image/discourse_dev/postgres_dev.template.yml#L26-L42


      
          - exec: su postgres -c 'createdb discourse_development' || true
          - exec: su postgres -c 'psql discourse_development -c "grant all privileges on database discourse_development to discourse;"' || true
          - exec: su postgres -c 'psql discourse_development -c "alter schema public owner to discourse;"'
          - exec: su postgres -c 'psql discourse_development -c "create extension if not exists hstore;"'
          - exec: su postgres -c 'psql discourse_development -c "create extension if not exists pg_trgm;"'
          
          
- exec: su postgres -c 'createdb discourse_test' || true
          - exec: su postgres -c 'psql discourse_test -c "grant all privileges on database discourse_test to discourse;"' || true
          - exec: su postgres -c 'psql discourse_test -c "alter schema public owner to discourse;"'
          - exec: su postgres -c 'psql discourse_test -c "create extension if not exists hstore;"'
          - exec: su postgres -c 'psql discourse_test -c "create extension if not exists pg_trgm;"'
          
          
- exec: su postgres -c 'createdb discourse_test_multisite' || true
          - exec: su postgres -c 'psql discourse_test_multisite -c "grant all privileges on database discourse_test_multisite to discourse;"' || true
          - exec: su postgres -c 'psql discourse_test_multisite -c "alter schema public owner to discourse;"'
          - exec: su postgres -c 'psql discourse_test_multisite -c "create extension if not exists hstore;"'
          - exec: su postgres -c 'psql discourse_test_multisite -c "create extension if not exists pg_trgm;"'

Setup database user:

github.com

discourse/discourse_docker/blob/990519e2373ec32055a7742a407e81f4bd606ed4/templates/postgres.13.template.yml#L204-L207


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

I’m still trying to understand,

how authentication is done
where authentication is configured
how connection parameters should be set

Topic		Replies	Views
Backup fails on localhost with docker Dev	9	1314	October 13, 2021
Configure Discourse to use a separate PostgreSQL server Self-Hosting how-to	42	26589	December 22, 2023
Manually create and restore Discourse backups Sysadmins how-to	13	15687	June 16, 2022
Backup restore failing on clean dev docker env: FATAL: Peer authentication failed for user “postgres” Bug pr-welcome , dev-install	12	4384	July 2, 2024
Createdb: error: database creation failed: ERROR: database "discourse" already exists Installation	5	1274	July 13, 2023

Documentation request: Overview about database access and configuration in a development environment.

Related topics