Docker-compose: PostgreSQL and PgAdmin

docker-compose.yml

# Use postgres/example user/password credentials
version: '3.1'

services:
  db:
    image: "postgres:10.6"
    restart: always
    ports:
      - 5432:5432
    environment:
      POSTGRES_USER: ${POSTGRES_USER:-postgres}
      POSTGRES_PASSWORD: ${POSTGRES_PASSWORD:-changeme}
    volumes:
      - database-data:/var/lib/postgresql/data/ # persist data even if container shuts down
      - ./bootstrap:/docker-entrypoint-initdb.d

  pgadmin:
    image: adminer
    restart: always
    ports:
      - 8080:8080

volumes:
  database-data: # named volumes can be managed easier using docker-compose

You can use this SQL script in the bootstrap folder to create a new user on container's startup:

-- Create the database user
CREATE USER rponte WITH PASSWORD '123';

-- Create the database
CREATE DATABASE mydb WITH  OWNER      = rponte 
                           ENCODING   = 'UTF8' 
                           LC_CTYPE   = 'en_US.UTF-8' 
                           LC_COLLATE = 'en_US.UTF-8'
                           TEMPLATE   = template0;

-- Grant permissions for the created user
GRANT ALL PRIVILEGES ON DATABASE mydb TO rponte;

And also you can import a database via Docker command (or Docker-compose as well):

docker exec -i postgresql_db_1 psql -U postgres mydb < dump_20_04_02.sql &> dump_full.log

Running PostgreSQL 13.x container via command line:

docker run --name cdc-postgres -p 5432:5432 -e POSTGRES_PASSWORD=postgres -d postgres:13.3

We can start and stop the container as well:

docker container start cdc-postgres
docker container stop cdc-postgres

Running pg_activity to monitoring Postgres instance:

Just run the commands below to install in the container where the postgres is running:

docker-compose exec <pg_server_name> bash # or docker exec -i -t postgres bash
apt update && apt install pg-activity && pg_activity -U postgres

For more details, see this Reddit comment.