Re: warm standby issues
От
Julio Leyva
Тема
Re: warm standby issues
Дата
Msg-id
BLU102-W27D4BF281F7BA9A72BC42DA1DE0@phx.gbl
Ответ на
Re: warm standby issues (Charles Duffy)
Список
Дерево обсуждения
warm standby issues kevin kempter <kevin@kevinkempterllc.com>
Re: warm standby issues "Charles Duffy" <charles.duffy@gmail.com>
Re: warm standby issues Julio Leyva <jcleyva@hotmail.com>
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 This is my configuration in the primary D.B
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 по дате отправления
