Postgres Pro
Downloads
Home   >   mailing lists

Thread: postgresql HA solution for different network domain

postgresql HA solution for different network domain

From
Amine Tengilimoglu
Date:

Hi all;


I have question about postgresql HA solituons. I want to make a replication on two different network domains. The master is one side(10.100.34.21 etc.) the replica the other side(192.145.78.32 etc.). So these machines have different network. The application servers should not affect during failover so we should not change any thing on application servers..like ip.. we saw vip solution but that won't help on different ip blocks... Do u have any advice or idea about on it?



Thanks in advance...

Re: postgresql HA solution for different network domain

From
Nicolas Karolak
Date:
You can put a HAProxy between your application and database, with
something like that:
https://severalnines.com/blog/postgresql-load-balancing-using-haproxy-keepalived

Regards,
Nicolas KAROLAK | SysAdmin
6-8, rue André Voguet - 94200 Ivry-sur-Seine
+33 1 77 56 77 96 | www.ubicast.eu | www.ubicast.tv
Le sam. 15 sept. 2018 à 08:11, Amine Tengilimoglu
<aminetengilimoglu@gmail.com> a écrit :
>
> Hi all;
>
>
> I have question about postgresql HA solituons. I want to make a replication on two different network domains. The
masteris one side(10.100.34.21 etc.) the replica the other side(192.145.78.32 etc.). So these machines have different
network.The application servers should not affect during failover so we should not change any thing on application
servers..likeip.. we saw vip solution but that won't help on different ip blocks... Do u have any advice or idea about
onit? 
>
>
>
> Thanks in advance...