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

2008-12-11 Thread Duco Fijma
Hello, 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. However, I'm having difficulties seeing how multiple instances of pgpool, in general, can

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

2008-12-11 Thread Daniel . Crespo
Hello, I have the exact same doubt. However, in my system, appservers A and B don't run at the same time. While A is active, B is inactive and viceversa. In the case A becomes unavailable, B takes over. So, the scenario in this case would be: Pgpool in both appservers are running and connected

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

2008-12-11 Thread Tatsuo Ishii
Hello, 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 additional