PostgreSQL
Backup
pg_dump
- pg_dump -U username table > file.bak
pg_dump -U postgres project > backup_db.bakRestore
- psql -U
< .sql
psql -U postgres project < backup.bak- pg_restore -U
-d -1 .dump
pg_restore -U postgres -d project -1 backup.dumpcat dump.sql | docker exec