PostgreSQL running on Docker.

⚠️ For development use only

• Copy the sample config file:

  cp .env.sample .env 

• Edit the config file and set the following values:

  POSTGRES_USER=db_user POSTGRES_PASSWORD=db_password POSTGRES_DB=db_name 

• Launch the container:

  ./start-container.sh 

• Verify the database is up by connecting to it using an external client, i.e. Postico

• Create a database user for the application:

  -- Uncomment if recreating role on existing instance -- DROP OWNED BY app_user CASCADE; DROP ROLE IF EXISTS app_user; CREATE ROLE app_user WITH INHERIT LOGIN PASSWORD NULL; GRANT CREATE ON DATABASE db_name TO app_user; ALTER ROLE app_user WITH PASSWORD 'PASSWORD'; -- Uncomment if creating dedicated schema for app (you should be!) -- Sets app user's default search path to app's schema -- ALTER ROLE app_user SET search_path TO "app_schema","public";

• To stop the container and delete the associated volume:

  docker-compose down --volumes 

  Note: this will delete the database

• This docker-compose file creates a private Docker network locally called db-network-private - you can connect other containers directly to this network and the database will be available using the following connection string:

  postgresql://username:password@postgres-db:5432/database 

• Install psql client on macOS:

  brew install libpq brew link --force libpq # Connect to the database: psql --host localhost --username=db_user --dbname=db_name

• To connect directly to the container's shell:

  # Find container ID docker ps -a # Connect to container: docker exec -it CONTAINER_ID bash