How to backup Postgresql

lbatters

Artem

Posted on April 25, 2021

How to backup Postgresql

If your Postgres in docker container use pg_dumpall to backup:

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

and then restore it:

cat dump_24-04-2021_20_50_17.sql | docker exec -i some-postgres  psql -U postgres
Enter fullscreen mode Exit fullscreen mode

If you want to play with the current command we can run a new docker container with postgres, create table, and check how a command is working.

Start a container:

docker run --name some-postgres -e POSTGRES_PASSWORD=pass -d postgres
Enter fullscreen mode Exit fullscreen mode

Go inside the container:

docker exec -it some-postgres bash
Enter fullscreen mode Exit fullscreen mode

Start psql console:

psql -U postgres
Enter fullscreen mode Exit fullscreen mode

Create table:

CREATE TABLE first_table (column1 int);
Enter fullscreen mode Exit fullscreen mode

And then you can do anything you want :)

💖 💪 🙅 🚩
lbatters
Artem

Posted on April 25, 2021

Join Our Newsletter. No Spam, Only the good stuff.

Sign up to receive the latest update from our blog.

Related

How to backup Postgresql
postgres How to backup Postgresql

April 25, 2021