Skip site navigation (1) Skip section navigation (2)

Re: warm standby issues

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 (view raw or flat)
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 


In response to

pgsql-admin by date

Next:From: Thomas BräutigamDate: 2008-04-29 01:08:26
Subject: Remove Postgres from Solaris 10
Previous:From: Brian ModraDate: 2008-04-28 07:55:30
Subject: Re: Problem with GeomFromText('POINT(...

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group