[Pgpool-general] Online recovery + WAL archiving

Jaume Sabater jsabater at gmail.com
Tue Apr 14 07:27:47 UTC 2009


On Wed, Apr 8, 2009 at 7:23 PM, Harold Lim <rold_50 at yahoo.com> wrote:

> 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'

I set archive_command to 'exit '0' and reload PostgreSQL, hence I
don't have to stop the cluster.

-- 
Jaume Sabater
http://linuxsilo.net/

"Ubi sapientas ibi libertas"


More information about the Pgpool-general mailing list