kevinke · November 22, 2018 03:19 · Nov 22, 2018 · Nov 22, 2018 · Sep 18, 2018 · Sep 18, 2018
diff --git a/pg_dump_restore.sql b/pg_dump_restore.sql
@@ -50,4 +50,8 @@ and restore with this:
 
 pg_restore 'pr_pro_db_test.dump' -F c -v -O -d ghl_pr_development -U 'postgres' -h localhost -p 15432
 
-don't need -c and -C if you restore to another database
+don't need -c and -C if you restore to another database
+
+create database with owner
+
+createdb -e -O <username> digital -h <host> -p <port> -U <root>
diff --git a/pg_dump_restore.md → pg_dump_restore.sql b/pg_dump_restore.md → pg_dump_restore.sql
diff --git a/pg_dump_restore.md b/pg_dump_restore.md
@@ -44,4 +44,10 @@ WHERE
 
   -- don't kill the connections to other databases
 
-  AND datname = 'database_name';
+  AND datname = 'database_name';
+
+and restore with this:
+
+pg_restore 'pr_pro_db_test.dump' -F c -v -O -d ghl_pr_development -U 'postgres' -h localhost -p 15432
+
+don't need -c and -C if you restore to another database
diff --git a/pg_dump_restore.md b/pg_dump_restore.md
@@ -30,18 +30,18 @@ connection related param
 
 SELECT
 
-    pg_terminate_backend(pid) 
+  pg_terminate_backend(pid) 
 
 FROM
 
-    pg_stat_activity 
+  pg_stat_activity 
 
 WHERE
 
-    -- don't kill my own connection!
+  -- don't kill my own connection!
 
-    pid <> pg_backend_pid()
+  pid <> pg_backend_pid()
 
-    -- don't kill the connections to other databases
+  -- don't kill the connections to other databases
 
-    AND datname = 'database_name';
+  AND datname = 'database_name';
diff --git a/pg_dump_restore.md b/pg_dump_restore.md
@@ -27,12 +27,21 @@ connection related param
  -d: dbname
 
 [//]: # kill active session before restore db dump
-SELECT 
+
+SELECT
+
     pg_terminate_backend(pid) 
-FROM 
+
+FROM
+
     pg_stat_activity 
-WHERE 
+
+WHERE
+
     -- don't kill my own connection!
+
     pid <> pg_backend_pid()
+
     -- don't kill the connections to other databases
+
     AND datname = 'database_name';
diff --git a/pg_dump_restore.md b/pg_dump_restore.md
@@ -3,18 +3,27 @@ pg_dump -F c -v -O -c --if-exists -C -U 'root' -h '139.198.176.101' -p '15432' -
 dump related param
 
  -f [file path]: send output to the specified file
+
  -F [format]: c is for custom format
+
  -v: verbose
+
  -O: (an upcase 'Oscar') do not output commands to set ownership of objects
+
  -c: output commands to clean (drop) database objects prior to outputting the commands for creating them
+
  --if-exists: se conditional commands (i.e. add an IF EXISTS clause) when cleaning database objects.
+
  -C: begin the output with a command to create the database itself and reconnect to the created database.
 
 connection related param
 
  -h: host
+
  -p: port
+
  -U: user
+
  -d: dbname
 
 [//]: # kill active session before restore db dump

diff --git a/pg_dump_restore.md b/pg_dump_restore.md
@@ -0,0 +1,29 @@
+pg_dump -F c -v -O -c --if-exists -C -U 'root' -h '139.198.176.101' -p '15432' -d 'qingcloud' -f 'pr_pro_db_test.dump'
+
+dump related param
+
+ -f [file path]: send output to the specified file
+ -F [format]: c is for custom format
+ -v: verbose
+ -O: (an upcase 'Oscar') do not output commands to set ownership of objects
+ -c: output commands to clean (drop) database objects prior to outputting the commands for creating them
+ --if-exists: se conditional commands (i.e. add an IF EXISTS clause) when cleaning database objects.
+ -C: begin the output with a command to create the database itself and reconnect to the created database.
+
+connection related param
+
+ -h: host
+ -p: port
+ -U: user
+ -d: dbname
+
+[//]: # kill active session before restore db dump
+SELECT 
+    pg_terminate_backend(pid) 
+FROM 
+    pg_stat_activity 
+WHERE 
+    -- don't kill my own connection!
+    pid <> pg_backend_pid()
+    -- don't kill the connections to other databases
+    AND datname = 'database_name';
No results found