Re: [GENERAL] Warm Standby Setup Documentation

2010-03-29 Thread Ogden
On Mar 28, 2010, at 7:45 PM, Yar Tykhiy wrote: > On Fri, Mar 26, 2010 at 01:35:43PM -0500, Ogden wrote: >> On Mar 26, 2010, at 1:32 PM, Greg Smith wrote: >> >>> Bryan Murphy wrote: The one thing you should be aware of is that when you fail over, your spare has no spares. I have not f

Re: [GENERAL] Warm Standby Setup Documentation

2010-03-28 Thread Greg Smith
Bryan Murphy wrote: On Fri, Mar 26, 2010 at 1:32 PM, Greg Smith > wrote: If there's another server around, you can have your archive_command on the master ship to two systems, then use the second one as a way to jump-start this whole process. After f

Re: [GENERAL] Warm Standby Setup Documentation

2010-03-28 Thread Greg Smith
Ogden wrote: How is it possible to use the archive_command to ship to different ones? archive_command = 'rsync -a %p postg...@192.168.x.x:/usr/local/pgsql/walfiles/%f The examples in the manual lead one toward putting a full command line into the script. I personally never do that; I cal

Re: [GENERAL] Warm Standby Setup Documentation

2010-03-28 Thread Yar Tykhiy
On Fri, Mar 26, 2010 at 01:35:43PM -0500, Ogden wrote: > On Mar 26, 2010, at 1:32 PM, Greg Smith wrote: > > > Bryan Murphy wrote: > >> The one thing you should be aware of is that when you fail over, your > >> spare has no spares. I have not found a way around this problem yet. So, > >> when y

Re: [GENERAL] Warm Standby Setup Documentation

2010-03-26 Thread Bryan Murphy
On Fri, Mar 26, 2010 at 1:32 PM, Greg Smith wrote: > If there's another server around, you can have your archive_command on the > master ship to two systems, then use the second one as a way to jump-start > this whole process. After fail-over, just start shipping from the new > primary to that 3

Re: [GENERAL] Warm Standby Setup Documentation

2010-03-26 Thread Ogden
On Mar 26, 2010, at 1:32 PM, Greg Smith wrote: > Bryan Murphy wrote: >> The one thing you should be aware of is that when you fail over, your spare >> has no spares. I have not found a way around this problem yet. So, when >> you fail over, there is a window where you have no backups while yo

Re: [GENERAL] Warm Standby Setup Documentation

2010-03-26 Thread Greg Smith
Bryan Murphy wrote: The one thing you should be aware of is that when you fail over, your spare has no spares. I have not found a way around this problem yet. So, when you fail over, there is a window where you have no backups while you're building the new spares. This can be pretty nerve w

Re: [GENERAL] Warm Standby Setup Documentation

2010-03-24 Thread Bryan Murphy
On Mon, Mar 22, 2010 at 9:21 AM, Ogden wrote: > I have looked all over but could not find any detailed docs on setting up a > warm standby solution using PostgreSQL 8.4. I do know of > http://www.postgresql.org/docs/8.4/static/warm-standby.html but was > wondering if there was a more detailed doc

[GENERAL] Warm Standby Setup Documentation

2010-03-22 Thread Ogden
I have looked all over but could not find any detailed docs on setting up a warm standby solution using PostgreSQL 8.4. I do know of http://www.postgresql.org/docs/8.4/static/warm-standby.html but was wondering if there was a more detailed document on this topic. Are people using this as a via