Login

airikr / Backup and restore PostgreSQL via Docker

Last active 4 months ago

Like 0
backup database linux restore

airikr revised this gist 9 months ago · f6c1928

No changes

airikr revised this gist 2 years ago · 9c25253

1 file changed, 1 insertion, 1 deletion

backup-restore.txt
@@ -2,4 +2,4 @@
2 2 docker exec -i <container-name> /bin/bash -c "PGPASSWORD=<passwd> pg_dump --username <user> <db-name>" > ~/db.sql
3 3
4 4 # RESTORE
5 - cat db.sql | docker exec -i <container-name> psql -U <user>
5 + cat db.sql | docker exec -i <container-name> psql -U <user> <db-name>

airikr revised this gist 2 years ago · 1745ec2

1 file changed

gistfile1.txt renamed to backup-restore.txt

File renamed without changes

airikr revised this gist 2 years ago · 33260b9

1 file changed, 1 insertion, 1 deletion

gistfile1.txt
@@ -2,4 +2,4 @@
2 2 docker exec -i <container-name> /bin/bash -c "PGPASSWORD=<passwd> pg_dump --username <user> <db-name>" > ~/db.sql
3 3
4 4 # RESTORE
5 - cat your_dump.sql | docker exec -i your-db-container psql -U postgres
5 + cat db.sql | docker exec -i <container-name> psql -U <user>

airikr revised this gist 2 years ago · 820d04b

1 file changed, 1 insertion, 1 deletion

gistfile1.txt
@@ -1,5 +1,5 @@
1 1 # BACKUP
2 - docker exec -i <container-name> /bin/bash -c "PGPASSWORD=<passwd> pg_dump --username <user> <db-name>" > ~/miniflux-db.sql
2 + docker exec -i <container-name> /bin/bash -c "PGPASSWORD=<passwd> pg_dump --username <user> <db-name>" > ~/db.sql
3 3
4 4 # RESTORE
5 5 cat your_dump.sql | docker exec -i your-db-container psql -U postgres

airikr revised this gist 2 years ago · abace68

1 file changed, 5 insertions

gistfile1.txt (file created)
@@ -0,0 +1,5 @@
1 + # BACKUP
2 + docker exec -i <container-name> /bin/bash -c "PGPASSWORD=<passwd> pg_dump --username <user> <db-name>" > ~/miniflux-db.sql
3 +
4 + # RESTORE
5 + cat your_dump.sql | docker exec -i your-db-container psql -U postgres