Re: warm standby issues - Mailing list pgsql-admin

From Julio Leyva
Subject Re: warm standby issues
Date
Msg-id BLU102-W27D4BF281F7BA9A72BC42DA1DE0@phx.gbl
Whole thread Raw
In response to Re: warm standby issues  ("Charles Duffy" <charles.duffy@gmail.com>)
List pgsql-admin
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'
archive_timeout = 60 

This is the recovery.conf in the backup server
restore_command = 'pg_standby -l /data01/wal_files %f %p %r -t /tmp/pgsql.trigger.5432 2>>/tmp/standby.log'


Hope this help you


pgsql-admin by date:

Previous
From: "Brian Modra"
Date:
Subject: Re: Problem with GeomFromText('POINT(...
Next
From: Thomas Bräutigam
Date:
Subject: Remove Postgres from Solaris 10