[pgpool-general: 8291] Re: Load Balancing, Fail Over and Remote Site replication

[Bo Peng]

Hello,

> My question is: Is there any way to set up replication to a remote site that coexists with PGPool-II?

If you wish to use Pgpool-II to synchronize all PostgreSQL servers
without using PostgreSQL's streaming replication,
you can use Pgpool-II's "snapshot isolation mode" or "native replication mode".

[Clustering mode of Pgpool-II]
https://www.pgpool.net/docs/latest/en/html/configuring-pgpool.html#RUNNING-MODE

Regears,

> Hi all
> 
> I have this project that requires High Availability, Load Balancing and
> Disaster Recovery. As such, I've been looking at the different solutions
> available with Postgres and found PGPool-II. Which seems to fit the bill
> quite well for HA and Load Balancing. My question is: Is there any way to
> set up replication to a remote site that coexists with PGPool-II?
> 
> Thanks all
> 
> Daniel Cristini


-- 
Bo Peng <pengbo at sraoss.co.jp>
SRA OSS, Inc. Japan
https://www.sraoss.co.jp/