From: | Julio Leyva <jcleyva(at)hotmail(dot)com> |
---|---|
To: | Charles Duffy <charles(dot)duffy(at)gmail(dot)com>, kevin kempter <kevin(at)kevinkempterllc(dot)com> |
Cc: | <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: warm standby issues |
Date: | 2008-04-28 14:36:47 |
Message-ID: | BLU102-W27D4BF281F7BA9A72BC42DA1DE0@phx.gbl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Bräutigam | 2008-04-29 01:08:26 | Remove Postgres from Solaris 10 |
Previous Message | Brian Modra | 2008-04-28 07:55:30 | Re: Problem with GeomFromText('POINT(... |