diff options
| author | luxagraf <sng@luxagraf.net> | 2023-06-02 08:42:17 -0500 |
|---|---|---|
| committer | luxagraf <sng@luxagraf.net> | 2023-06-02 08:42:17 -0500 |
| commit | 976d60d506f70ee7ff916079c434290482c22f5a (patch) | |
| tree | b9803900d46fe83b46f3e202a0ced40c686eec3f /tech | |
| parent | 1c10a64d88900cd09177c647d853c85e60a5ddc9 (diff) | |
moved a few things around
Diffstat (limited to 'tech')
| -rw-r--r-- | tech/psql dump and restore.txt | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/tech/psql dump and restore.txt b/tech/psql dump and restore.txt new file mode 100644 index 0000000..92dc15d --- /dev/null +++ b/tech/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} + + |