Re: [ADMIN] warm standby issues

2008-04-28 Thread Julio Leyva
I have setup this feature using postgresql 8.3.1 on a suse linux version and pg_standby as a recovery script, works very good and I use rsync as a script to ship logs This is my configuration in the primary D.B archive_mode = on archive_command = 'rsync -atz %p backup:/data01/wal_files/%f

Re: [ADMIN] warm standby issues

2008-04-27 Thread Charles Duffy
Hi Kevin, On Mon, Apr 28, 2008 at 7:34 AM, kevin kempter <[EMAIL PROTECTED]> wrote: > Hi List; > > I'm setting up a warm standby server on version 8.1.9 > I didn't think 8.1 supported warm-standby... > I setup a recovery.sh script to keep the standby cluster in recovery mode > waiting for the

[ADMIN] warm standby issues

2008-04-27 Thread kevin kempter
Hi List; I'm setting up a warm standby server on version 8.1.9 I setup a recovery.sh script to keep the standby cluster in recovery mode waiting for the next WAL segment. everything works fine as long as the standby server is in recovery mode. I see the recovery taking place in the postg