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/
> 
> 
>