Backup/Restore a dockerized PostgreSQL database

by

Backup your databases

docker exec -t your-db-container pg_dumpall -c -U postgres > dump_`date +%d-%m-%Y"_"%H_%M_%S`.sql

Restore your databases

cat your_dump.sql | docker exec -i your-db-container psql -U postgres

More Related Contents:

  1. Starting and populating a Postgres container in Docker
  2. Keep PostgreSQL from sometimes choosing a bad query plan
  3. Copying PostgreSQL database to another server
  4. Primary keys with Apache Spark
  5. How do I backup a database file to the SD card on Android?
  6. How can I put a database under git (version control)?
  7. How do IMMUTABLE, STABLE and VOLATILE keywords effect behaviour of function?
  8. Store query result in a variable using in PL/pgSQL
  9. Can I rollback a transaction I’ve already committed? (data loss)
  10. Kill a postgresql session/connection
  11. How to backup sqlite database?
  12. PostgreSQL: Drop PostgreSQL database through command line [closed]
  13. Do stored procedures run in database transaction in Postgres?
  14. Import SQL dump into PostgreSQL database
  15. how to use Blob datatype in Postgres
  16. How can I solve Postgresql SCRAM authentication problem?
  17. Convert SQLITE SQL dump file to POSTGRESQL
  18. Is it better to use multiple databases with one schema each, or one database with multiple schemas? [closed]
  19. How to login and authenticate to Postgresql after a fresh install?
  20. PostgreSQL Database Log Transaction
  21. Connect to a heroku database with pgadmin
  22. How do I automatically update a timestamp in PostgreSQL
  23. Adding a new value to an existing ENUM Type
  24. How can I import a .sql file into my Heroku postgres database?
  25. Should each and every table have a primary key?
  26. When and why are database joins expensive?
  27. Error: pg_config executable not found when installing psycopg2 on Alpine in Docker
  28. XML data to PostgreSQL database [closed]
  29. Best representation of an ordered list in a database?
  30. SQL LIKE operator in Cloud Firestore?

Leave a Comment