search

kagxin / blog

个人博客：技术、随笔、生活
https://github.com/kagxin/blog/issues
7 stars 0 forks source link

postgresql #38

Open kagxin opened 5 years ago

kagxin commented 5 years ago

dump指定的数据库到指定的数据：

pg_dump -h hostNmame -U postgres -p 5432 databaseName | psql -U postgres databaseName

docker-compose

pgsqldb:
  container_name: pgsql
  image: postgres:10
  restart: always
  ports:
    - 5432:5432
  volumes:
    - /opt/pgsql/data:/var/lib/postgresql/data
  environment:
    POSTGRES_USER: postgres
    POSTGRES_PASSWORD: postgres
    POSTGRES_DB: test

ref: https://www.postgresql.org/docs/9.1/backup-dump.html https://hub.docker.com/_/postgres https://yeasy.gitbooks.io/docker_practice/compose/compose_file.html