Steve Singer ssinger at ca.afilias.info
Tue Jun 8 12:35:32 PDT 2010
---
 tools/slony1_dump.sh |   10 ++++++++++
 1 files changed, 10 insertions(+), 0 deletions(-)

diff --git a/tools/slony1_dump.sh b/tools/slony1_dump.sh
index b3b349d..dffd60c 100755
--- a/tools/slony1_dump.sh
+++ b/tools/slony1_dump.sh
@@ -69,6 +69,7 @@ done
 cat <<_EOF_
 start transaction;
 
+
 -- ----------------------------------------------------------------------
 -- SCHEMA $clname
 -- ----------------------------------------------------------------------
@@ -165,9 +166,18 @@ begin
 end;
 ' language plpgsql;
 
+set session_replication_role='replica';
+
 _EOF_
 
 
+
+for tab in $tables
+do
+	eval tabname=\$tabname_$tab
+	echo "truncate $tabname cascade;";
+done
+
 # ----
 # The remainder of this script is written in a way that
 # all output is generated by psql inside of one serializable
-- 
1.6.3.3


--------------000004020401010106030904
Content-Type: text/x-patch;
 name="0004-changes-so-log-shipping-continues-to-work-when-the-q.patch"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline;
 filename*0="0004-changes-so-log-shipping-continues-to-work-when-the-q.pa";
 filename*1="tch"



More information about the Slony1-patches mailing list