software:postgresql
Table of Contents
PostgreSQL
How-tos
Local Postgres
Backup all your databases
sudo -u postgres pg_dumpall -c -U postgres > /tmp/my_awesome_backup.dump
Backup a single database
sudo -u postgres pg_dump -F p -O -d my_awesome_db > /tmp/my_awesome_db.dump
Dockerized Postgres
Backup a single database
docker exec -t my_awesome_container pg_dump -F p -O -d my_awesome_db > /tmp/my_awesome_db.dump
Backup all your databases
docker exec -t my_awesome_container pg_dumpall -c -U postgres > /tmp/my_awesome_backup.dump
Restore a single database
cat /tmp/my_awesome_db.dump | docker exec -i my_awesome_db psql -U my_awesome_user
Restore all your databases
cat /tmp/my_awesome_backup.dump | docker exec -i my_awesome_container psql -U my_awesome_user
software/postgresql.txt · Last modified: 2021/04/28 06:25 by Michele Porelli