[Pgpool-general] Online recovery + WAL archiving

[Harold Lim]

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 harold at xxxxx:~/exchange/wal/%f < /dev/null'

Do I just set archive_mode to off?

Thanks,
Harold

--- On Wed, 4/8/09, Jaume Sabater <jsabater at gmail.com> wrote:

> From: Jaume Sabater <jsabater at gmail.com>
> Subject: Re: [Pgpool-general] Online recovery + WAL archiving
> To: rold_50 at yahoo.com
> Cc: pgpool-general at pgfoundry.org
> Date: Wednesday, April 8, 2009, 6:37 AM
> On Tue, Apr 7, 2009 at 1:42 AM, Harold Lim
> <rold_50 at yahoo.com> 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"