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
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
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