Skip to content

bashchkov/postgres-on-docker

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

4 Commits
 
 
 
 
 
 
 
 

Repository files navigation

PostgreSQL on Docker

The PostgreSQL object-relational database system provides reliability and data integrity.

Example docker-compose.yml for postgres:

version: "3"

volumes:
  db-data:
  db-backups:

services:
  db:
    restart: unless-stopped
    image: moxlive/postgres
    environment:
      - POSTGRES_DB=
      - POSTGRES_USER=
      - POSTGRES_PASSWORD=
      - POSTGRES_HOST=127.0.0.1
      - POSTGRES_PORT=5432
      - BACKUP_DIR_PATH=/backups
      - BACKUP_FILE_PREFIX=backup
    volumes:
      - db-data:/var/lib/postgresql/data
      - db-backups:/backups
  web:
    depends_on:
      - db

Create a database backup.

$ docker-compose exec db backup

View backups.

$ docker-compose exec db backups

Restore database from a backup.

$ docker-compose exec db restore [filename of an existing backup]

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published