On 7/19/07, Jan Wieck <JanWieck at yahoo.com> wrote:
>
> On 7/19/2007 12:58 AM, Mikko Partio wrote:
>
> No, only the slon of a real replica can actually write the log files.
> However, what might work in your case is to create a "fake" replica.
> Create a replica that has a slave-only trigger (using STORE TRIGGER) on
> every replicated table. The trigger fires BEFORE INSERT and all it does
> is RETURN NULL. And you subscribe the thing with no forwarding. That
> should create an empty replica that now can write the log shipping
> files. To get the initial content for the offline replica you must
> however stop the application and dump from the origin.



One question, the script slony1_dump.sh retrieves the sync-value for table
sl_setsync_offline from the sl_setsync -table. I modified the script so that
the data gets dumped from the origin node (since the subscriber is empty),
but the sl_setsync table is empty at the origin, Where can I get the correct
sync number (is select max(con_seqno) from sl_confirm ok) ?

Regards

MP
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20070720/=
c02d8639/attachment.htm