Christopher Browne cbbrowne
Wed Jul 27 21:49:18 PDT 2005
Darcy Buskermolen wrote:

>C) determine if the desired log shipping behavior is observed.
>  
>
Not the case for the SUBSCRIBE SET event.

It's easy to characterize by grabbing an extract of what is generated
for one table.
------------------------------------------------------------------------------------------------------------------------------------------------

delete from "public"."branches";copy "public"."branches" from stdin;
1       2112818 \N
\.
select "_T1".enableSubscriptionIndexes('"public"."branches"'); reindex
table "public"."branches"; analyze "public"."branches"; select
"_T1".maintenance_work_mem('16384');

------------------------------------------------------------------------------------------------------------------------------------------------

Problems:

1.  There should be a query of the following form at the beginning...

    select "_T1".disableSubscriptionIndexes('"public"."branches"');

2.  The functions enableSubscriptionIndexes(),
disableSubscriptionIndexes(), and maintenance_work_mem() are not defined
in tools/slony1_dump.sh

I'll see about sending you a patch for the latter...


More information about the Slony1-general mailing list