Differences

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

--- software:postgresql [2013/11/10 16:24] – created Michele Porelli
+++ software:postgresql [2021/04/28 04:25] (current) – [How-tos] Michele Porelli
@@ Line 1: / Line 1: @@
 ====== PostgreSQL ======
 ===== How-tos =====
-  * [[Create new DB|http://www.postgresql.org/docs/9.3/static/manage-ag-createdb.html]]
+  * [[http://www.postgresql.org/docs/9.3/static/manage-ag-createdb.html|Create new DB]]
-  * [[Create new DB and grant all permission to some users|http://www.cyberciti.biz/faq/howto-add-postgresql-user-account/]]
+  * [[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>