jagira/pg_backup_and_restore.sh

Created February 6, 2018 05:21

Star (1) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/jagira/35b2ba3a071c862e8c85cdbd3bee8003.js"></script>
Save jagira/35b2ba3a071c862e8c85cdbd3bee8003 to your computer and use it in GitHub Desktop.

Download ZIP

Revisions

jagira created this gist Feb 6, 2018.

pg_backup_and_restore.sh

-Original file line number
+Diff line change
@@ -0,0 +1,5 @@
+    # Take backup
+    pg_dump -F c -v DATABASE_NAME -f FILENAME.sql
+    # Restore from backup
+    pg_restore --verbose --clean --no-owner --no-acl --dbname DATABASE_NAME FILENAME.sql