Tim Lloyd tim.lloyd at censornet.com
Sat Mar 26 03:43:03 PDT 2011
Hi Venkat

I found a way to get Slony out of this state without rebuilding the db.

1) Connect to your database, e.g. psql <dbname> as user postgres

2) delete from _schema.sl_log_1;

3) select _schema.logswitch_finish();

4) select _schema.logswitch_start();

Replace _schema with the name of your cluster schema.

Kind regards,

Tim

-- 
Tim Lloyd
CensorNet Ltd
+44 (0) 845 230 9590 / tim.lloyd at censornet.com
www.censornet.com

(sent from my laptop)



More information about the Slony1-general mailing list