Re: [ADMIN] Warm Standby on 8.4.7

2011-04-14 Thread Jerry Sievers
Alanoly Andrews alano...@invera.com writes: Hello, Is it possible to set up a warm standby pair of postgres instances without using the pg_standby utility? The PG manuals appear to say it is possible. But I dont see the details of how to set this up. How do you keep the standby instance in

Re: [ADMIN] Warm Standby on 8.4.7

2011-04-14 Thread Simon Riggs
On Thu, Apr 14, 2011 at 1:06 PM, Alanoly Andrews alano...@invera.com wrote: Thanks, Simon, for your quick response. I'll try it out with your pg_standby utility. And...if I may ask you one more question on the subject, once the standby is up and running, is there a way to determine whether

[ADMIN] Warm Standby on 8.4.7

2011-04-13 Thread Alanoly Andrews
Hello, Is it possible to set up a warm standby pair of postgres instances without using the pg_standby utility? The PG manuals appear to say it is possible. But I don't see the details of how to set this up. How do you keep the standby instance in permanent recovery mode? Thanks. Alanoly.

Re: [ADMIN] Warm Standby on 8.4.7

2011-04-13 Thread Simon Riggs
On Wed, Apr 13, 2011 at 8:53 PM, Alanoly Andrews alano...@invera.com wrote: Is it possible to set up a warm standby pair of postgres instances without using the pg_standby utility? The PG manuals appear to say it is possible. But I don’t see the details of how to set this up. How do you keep