Hi Jaume, How do you disable the archive command and not the actual archiving?
In my postgresql.conf I have archive_mode = on archive_command = 'rsync -e "ssh -o StrictHostKeyChecking=no -i /opt/PostgreSQL/8.3/data/id_dsa -l harold" %p har...@xxxxx:~/exchange/wal/%f < /dev/null' Do I just set archive_mode to off? Thanks, Harold --- On Wed, 4/8/09, Jaume Sabater <[email protected]> wrote: > From: Jaume Sabater <[email protected]> > Subject: Re: [Pgpool-general] Online recovery + WAL archiving > To: [email protected] > Cc: [email protected] > Date: Wednesday, April 8, 2009, 6:37 AM > On Tue, Apr 7, 2009 at 1:42 AM, Harold Lim > <[email protected]> wrote: > > > I'm currently looking at the pgpool-ii > beginner's guide. > > I'm mainly interested in online recovery (e.g, > dynamically adding a new postgresql node). > > > > Do I have to enable wal archiving for all of my node? > or just for my first node? > > Only on the node that is acting as master during the online > recovery, > whichever it is at that moment, and you can turn it off > again (disable > the archive command, not the actual online archiving) after > it's > complete. > > > -- > Jaume Sabater > http://linuxsilo.net/ > > "Ubi sapientas ibi libertas" _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
