[Pgpool-general] Online recovery + WAL archiving

[Gerd Koenig]

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 harold at 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 <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"
> 
> 
>       
> _______________________________________________
> Pgpool-general mailing list
> Pgpool-general at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pgpool-general