Differences

This shows you the differences between two versions of the page.

--- software:postgresql [2013/11/10 16:25] – [How-tos] Michele Porelli
+++ software:postgresql [2021/04/28 04:25] (current) – [How-tos] Michele Porelli
@@ Line 4: / Line 4: @@
   * [[http://www.cyberciti.biz/faq/howto-add-postgresql-user-account/|Create new DB and grant all permission to some users]]
+==== Local Postgres ====
+=== Backup all your databases ===
+<code>sudo -u postgres pg_dumpall -c -U postgres > /tmp/my_awesome_backup.dump</code>
+=== Backup a single database ===
+<code>sudo -u postgres pg_dump -F p -O -d my_awesome_db > /tmp/my_awesome_db.dump</code>
+==== Dockerized Postgres ====
+=== Backup a single database ===
+<code>docker exec -t my_awesome_container pg_dump -F p -O -d my_awesome_db > /tmp/my_awesome_db.dump</code>
+=== Backup all your databases ===
+<code>docker exec -t my_awesome_container pg_dumpall -c -U postgres > /tmp/my_awesome_backup.dump</code>
+=== Restore a single database ===
+<code>cat /tmp/my_awesome_db.dump | docker exec -i my_awesome_db psql -U my_awesome_user</code>
+=== Restore all your databases ===
+<code>cat /tmp/my_awesome_backup.dump | docker exec -i my_awesome_container psql -U my_awesome_user</code>