[Pgpool-general] pgpool running on only one box?

[Guillaume Lelarge]

Le 31/03/2011 09:40, Micka a écrit :
> My idea was, and I didn't test it, it's:
> 
> Server 1                Server 2
> postgres 9 A          postgres9 B
> pgpool A               pgpool B
> application A         application B
> 
> The idea was :
> 
> - pgpool A is active, it's doing a streaming replication with postgres A and
> B.

pgPool-II doesn't do streaming replication. PostgreSQL does.

> -application A is communicating with pgpool A.
> - application B is communicating with pgpool A.
> 
> if the server 1 goes down, pgpool is starting, doing the failover command.
> The application B detect that pgpoolA is not working anymore, and try to
> communicate with pgpoolB.
> 

Should work.


-- 
Guillaume
 http://www.postgresql.fr
 http://dalibo.com