diff options
Diffstat (limited to 'psql dump and restore.txt')
| -rw-r--r-- | psql dump and restore.txt | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/psql dump and restore.txt b/psql dump and restore.txt new file mode 100644 index 0000000..92dc15d --- /dev/null +++ b/psql dump and restore.txt @@ -0,0 +1,11 @@ +psql back up and restore + +Backup: + + $ pg_dump -U {user-name} -hlocalhost -d {source_db} > {dumpfilename.sql} + +Restore: + + $ psql -U {user-name} -hlocalhost -d {desintation_db} < {dumpfilename.sql} + + |