From 976d60d506f70ee7ff916079c434290482c22f5a Mon Sep 17 00:00:00 2001 From: luxagraf Date: Fri, 2 Jun 2023 08:42:17 -0500 Subject: moved a few things around --- tech/psql dump and restore.txt | 11 +++++++++++ 1 file changed, 11 insertions(+) create mode 100644 tech/psql dump and restore.txt (limited to 'tech') 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} + + -- cgit v1.2.3-70-g09d2