Tue Jun 8 12:35:32 PDT 2010
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
--- 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"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-patches mailing list