On Fri, 15 Jun 2012, Raghav wrote:
Hi,
I have compiled Slony-I 2.1 to PG 9.1. My replication setup went well and I
could replicate the
data. In my testing am using Slony Log shipping and generating .SQL files.
As per documentation all .sql files are tracked with sl_archive_tracking
table, however if
execute a query it says its not exist.
postgres=# select * from _myrep.sl_archive_tracking;
ERROR: relation "_myrep.sl_archive_tracking" does not exist
LINE 1: select * from _myrep.sl_archive_tracking;
tools/slony1_dump.sh should create this table on the log shipping
destination. This script dumps the data from the replica running slon in
log shipping mode and restores it + some extra functions/tables to on the
destination/target node.
Q: Is this table deprecated in Slony-I 2.1 or its been renamed to
sl_archive_counter ?
--
RegardsRaghav
Blog: htt://raghavt.blogspot.com/
_______________________________________________
Slony1-general mailing list
[email protected]
http://lists.slony.info/mailman/listinfo/slony1-general
