Re: WAL shipping question

> This basically archives the data in the primary server
itself...right!!!
> But how can I set up continuous archiving from primary to a directory

> (WAL archive directory) on the stand-by server ?

>>The closest thing to a worked out example of how to do this I'm aware
of
>>is at http://archives.postgresql.org/sydpug/2006-10/msg00001.php

I tried this example
I have the primary and standby server setup. The primary server is archiving the wal segments in the standby server's directory. My question is that, as per that example in step 15 the standby server should gives messages in its log whenever some WAL activity is triggered in the master. I see the archive directory in standby server getting filled up, but there are no log messages generated. Whay? What am I missing here?

Also what does step 16 mean in that above example?
" To initiate a failover from the master to the slave, create the 'trigger file':
touch ~/pg82demo/trigger
This should immediately cause the slave to finish processing archived
segments, exit recovery mode, and come up ready for use "

Does the wal archives are applied to the standby server at this point and it has all the
contents(tables,indexes,tabledata etc) at this point?

Thanks
sharmila

____________________________________________________________________________________
Looking for last minute shopping deals?
Find them fast with Yahoo! Search. http://tools.search.yahoo.com/newsearch/category.php?category=shopping