Hi Harold, Harold Lim schrieb: > 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?
Yes, that's it. regards...GERD... > > 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 _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
