[pgpool-general: 3657] postgresql and pgpool - how best to set up a no data loss solution

Derek derek_kouch at yahoo.com.au
Mon Apr 27 09:59:56 JST 2015


Hi,

> I've been looking into pgpool-II and how I could use its automatic failover to manage the postgresql databases in a HA environment.
> 
> My question is how can I set up pgpool and / or postgresql so that there is no data loss when a disaster occurs. ie. all committed transactions are sent and loaded at the standby database server as part of the failover.
> 
> I want to use an asynchronous connection between the master and standby database servers.

Kind regards,
Derek.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20150427/30e5a508/attachment.html>


More information about the pgpool-general mailing list