User Tools

Site Tools


software:postgresql

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