DEV Community

freecoderzhaoshuai
freecoderzhaoshuai

Posted on

 

Backup/Restore a dockerized PostgreSQL database

Backup your databases
docker exec -t your-db-container pg_dumpall -c -U postgres > dump_date +%d-%m-%Y"_"%H_%M_%S.sql

Restore your databases
cat your_dump.sql | docker exec -i your-db-container psql -U postgres

Top comments (0)

Timeless DEV post...

Git Concepts I Wish I Knew Years Ago

The most used technology by developers is not Javascript.

It's not Python or HTML.

It hardly even gets mentioned in interviews or listed as a pre-requisite for jobs.

I'm talking about Git and version control of course.

One does not simply learn git