Re: postgresql HA solution for different network domain

From: Nicolas Karolak <nicolas(dot)karolak(at)ubicast(dot)eu>
To: aminetengilimoglu(at)gmail(dot)com
Cc: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: postgresql HA solution for different network domain
Date: 2018-09-17 07:44:58
Message-ID: CAO8Scz6+RqHhdswGcRtHtOQ8KXFqCYT8Eb=_LyANG7vE-FDcCg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(at)gmail(dot)com> a écrit :
>
> 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...

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Mariel Cherkassky 2018-09-17 12:15:44 Segmentation fault postgres 9.6
Previous Message Tom Lane 2018-09-16 16:25:17 Re: Difference between C and en_US.UTF-8 Collate & CType in Postgres 10.x