Re: [Pgpool-general] inconsistency when using two pgpool instances in warm standby?

2008-12-15 Thread Jaume Sabater
Tatsuo Ishii wrote: I'm designing a warm-standby Postgres/pgpool system accepting connections from a number of application servers. Of course, running a single instance of pgpool introduces a single point of failure. To avoid the SPOF, you could use pgpool-HA or whatever Hot/Standby

Re: [Pgpool-general] inconsistency when using two pgpool instances in warm standby?

2008-12-15 Thread Marcelo Martins
I have not checked on pgpool-HA but I'm very inrest in checking that out now since the Ucarp solution that I have right now is on a dev environment. Please let us know when that tutorial is live :) thanks Marcelo PostgreSQL DBA Linux/Solaris System Administrator http://www.zeroaccess.org On

Re: [Pgpool-general] inconsistency when using two pgpool instances in warm standby?

2008-12-15 Thread Marcelo Martins
Tatsuo, I also have some online-recory scripts that I have been meaning to post on the list that perhaps some could use it as another example together with the ones you currently provide Marcelo PostgreSQL DBA Linux/Solaris System Administrator http://www.zeroaccess.org On Dec 13, 2008,

Re: [Pgpool-general] inconsistency when using two pgpool instances in warm standby?

2008-12-15 Thread Tatsuo Ishii
Marcelo, Great. Please post! -- Tatsuo Ishii SRA OSS, Inc. Japan Tatsuo, I also have some online-recory scripts that I have been meaning to post on the list that perhaps some could use it as another example together with the ones you currently provide Marcelo PostgreSQL DBA

Re: [Pgpool-general] inconsistency when using two pgpool instances in warm standby?

2008-12-15 Thread Jaume Sabater
Tatsuo Ishii wrote: Great. Please post! Attached you'll find mine. They use rsync for the base backup. Heartbeat does not need any scripts. I also have some online-recory scripts that I have been meaning to post on the list that perhaps some could use it as another example together

Re: [Pgpool-general] pgpool Online Recovery scripts example

2008-12-15 Thread Daniel . Crespo
Thanks for sharing! I have similar scripts to copy-base-backup and pgpool-start-remote. I think I'm not needing pgpool-recovery-pitr. Am I wrong or the pitr one is in case I don't use a two stages recovery? Thanks, Daniel -Original Message- From: pgpool-general-boun...@pgfoundry.org

Re: [Pgpool-general] inconsistency when using two pgpool instances in warm standby?

2008-12-15 Thread Yutaka Tanida
Hi Edward, Thank you for your interesting script. However this script has better pgpool-II handling than pgpool-HA's. Unfortunately I can't merge into pgpool-HA because of license conflict. Pgpool-HA's is BSD style but yours is GPL... Here's some remarks. -I do not recommend to use /etc/init.d