pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedPostgres cluster HA
6+ messages / 5 participants
[nested] [flat]
* Postgres cluster HA
@ 2019-11-14 12:21 Ebin Jozer <ebinjozer@gmail.com>
2019-11-14 13:15 ` RE: Postgres cluster HA ahmed.eljami@orange.com
0 siblings, 1 reply; 6+ messages in thread
From: Ebin Jozer @ 2019-11-14 12:21 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
Hi guys,
There is no in-build feature for postgres cluster HA like Oracle RAC. Our
company planning to build postgres cluster, are you guys using any tool to
achieve postgres cluster HA. In the below link postgres clustring tool are
given. Did any one of you used any clustering tool?
https://wiki.postgresql.org/wiki/Replication,_Clustering,_and_Connection_Pooling
^ permalink raw reply [nested|flat] 6+ messages in thread
* RE: Postgres cluster HA
2019-11-14 12:21 Postgres cluster HA Ebin Jozer <ebinjozer@gmail.com>
@ 2019-11-14 13:15 ` ahmed.eljami@orange.com
2019-11-14 13:45 ` Re: Postgres cluster HA Ebin Jozer <ebinjozer@gmail.com>
0 siblings, 1 reply; 6+ messages in thread
From: ahmed.eljami@orange.com @ 2019-11-14 13:15 UTC (permalink / raw)
To: Ebin Jozer <ebinjozer@gmail.com>; pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Hi,
We are evaluating Patroni (https://github.com/zalando/patroni), discovered during PG Conf Europe and it seems to be working fine according to the people who use it .
De : Ebin Jozer [mailto:ebinjozer@gmail.com]
Envoyé : jeudi 14 novembre 2019 13:22
À : pgsql-admin@lists.postgresql.org
Objet : Postgres cluster HA
Hi guys,
There is no in-build feature for postgres cluster HA like Oracle RAC. Our company planning to build postgres cluster, are you guys using any tool to achieve postgres cluster HA. In the below link postgres clustring tool are given. Did any one of you used any clustering tool?
https://wiki.postgresql.org/wiki/Replication,_Clustering,_and_Connection_Pooling
_________________________________________________________________________________________________________________________
Ce message et ses pieces jointes peuvent contenir des informations confidentielles ou privilegiees et ne doivent donc
pas etre diffuses, exploites ou copies sans autorisation. Si vous avez recu ce message par erreur, veuillez le signaler
a l'expediteur et le detruire ainsi que les pieces jointes. Les messages electroniques etant susceptibles d'alteration,
Orange decline toute responsabilite si ce message a ete altere, deforme ou falsifie. Merci.
This message and its attachments may contain confidential or privileged information that may be protected by law;
they should not be distributed, used or copied without authorisation.
If you have received this email in error, please notify the sender and delete this message and its attachments.
As emails may be altered, Orange is not liable for messages that have been modified, changed or falsified.
Thank you.
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Postgres cluster HA
2019-11-14 12:21 Postgres cluster HA Ebin Jozer <ebinjozer@gmail.com>
2019-11-14 13:15 ` RE: Postgres cluster HA ahmed.eljami@orange.com
@ 2019-11-14 13:45 ` Ebin Jozer <ebinjozer@gmail.com>
2019-11-14 13:53 ` Re: Postgres cluster HA Michael Banck <michael.banck@credativ.de>
0 siblings, 1 reply; 6+ messages in thread
From: Ebin Jozer @ 2019-11-14 13:45 UTC (permalink / raw)
To: ahmed.eljami@orange.com; +Cc: pgsql-admin@lists.postgresql.org
Thanks Ahmed. Is this open source and any support we can get?
Any other tools we have with support?
On Thu, 14 Nov, 2019, 6:45 PM , <ahmed.eljami@orange.com> wrote:
>
>
> Hi,
>
>
>
> We are evaluating Patroni (https://github.com/zalando/patroni),
> discovered during PG Conf Europe and it seems to be working fine according
> to the people who use it .
>
>
>
>
>
> *De :* Ebin Jozer [mailto:ebinjozer@gmail.com]
> *Envoyé :* jeudi 14 novembre 2019 13:22
> *À :* pgsql-admin@lists.postgresql.org
> *Objet :* Postgres cluster HA
>
>
>
> Hi guys,
>
> There is no in-build feature for postgres cluster HA like Oracle RAC. Our
> company planning to build postgres cluster, are you guys using any tool to
> achieve postgres cluster HA. In the below link postgres clustring tool are
> given. Did any one of you used any clustering tool?
>
>
>
>
> https://wiki.postgresql.org/wiki/Replication,_Clustering,_and_Connection_Pooling
>
>
>
>
>
>
>
>
>
>
>
> _________________________________________________________________________________________________________________________
>
> Ce message et ses pieces jointes peuvent contenir des informations confidentielles ou privilegiees et ne doivent donc
> pas etre diffuses, exploites ou copies sans autorisation. Si vous avez recu ce message par erreur, veuillez le signaler
> a l'expediteur et le detruire ainsi que les pieces jointes. Les messages electroniques etant susceptibles d'alteration,
> Orange decline toute responsabilite si ce message a ete altere, deforme ou falsifie. Merci.
>
> This message and its attachments may contain confidential or privileged information that may be protected by law;
> they should not be distributed, used or copied without authorisation.
> If you have received this email in error, please notify the sender and delete this message and its attachments.
> As emails may be altered, Orange is not liable for messages that have been modified, changed or falsified.
> Thank you.
>
>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Postgres cluster HA
2019-11-14 12:21 Postgres cluster HA Ebin Jozer <ebinjozer@gmail.com>
2019-11-14 13:15 ` RE: Postgres cluster HA ahmed.eljami@orange.com
2019-11-14 13:45 ` Re: Postgres cluster HA Ebin Jozer <ebinjozer@gmail.com>
@ 2019-11-14 13:53 ` Michael Banck <michael.banck@credativ.de>
2019-11-14 14:03 ` Re: Postgres cluster HA Pepe TD Vo <pepevo@yahoo.com>
0 siblings, 1 reply; 6+ messages in thread
From: Michael Banck @ 2019-11-14 13:53 UTC (permalink / raw)
To: Ebin Jozer <ebinjozer@gmail.com>; +Cc: ahmed.eljami@orange.com; pgsql-admin@lists.postgresql.org
Hi Ebin,
On Thu, Nov 14, 2019 at 07:15:45PM +0530, Ebin Jozer wrote:
> Thanks Ahmed. Is this open source and any support we can get?
Yes it is, you can get it at https://github.com/zalando/patroni/
Several Postgres consulting/support companies support Patroni.
Michael
--
Michael Banck
Projektleiter / Senior Berater
Tel.: +49 2166 9901-171
Fax: +49 2166 9901-100
Email: michael.banck@credativ.de
credativ GmbH, HRB Mönchengladbach 12080
USt-ID-Nummer: DE204566209
Trompeterallee 108, 41189 Mönchengladbach
Geschäftsführung: Dr. Michael Meskes, Jörg Folz, Sascha Heuer
Unser Umgang mit personenbezogenen Daten unterliegt
folgenden Bestimmungen: https://www.credativ.de/datenschutz
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Postgres cluster HA
2019-11-14 12:21 Postgres cluster HA Ebin Jozer <ebinjozer@gmail.com>
2019-11-14 13:15 ` RE: Postgres cluster HA ahmed.eljami@orange.com
2019-11-14 13:45 ` Re: Postgres cluster HA Ebin Jozer <ebinjozer@gmail.com>
2019-11-14 13:53 ` Re: Postgres cluster HA Michael Banck <michael.banck@credativ.de>
@ 2019-11-14 14:03 ` Pepe TD Vo <pepevo@yahoo.com>
2019-12-24 13:27 ` Re: Postgres cluster HA Amine Tengilimoglu <aminetengilimoglu@gmail.com>
0 siblings, 1 reply; 6+ messages in thread
From: Pepe TD Vo @ 2019-11-14 14:03 UTC (permalink / raw)
To: Ebin Jozer <ebinjozer@gmail.com>; Michael Banck <michael.banck@credativ.de>; +Cc: ahmed.eljami@orange.com; pgsql-admin@lists.postgresql.org
Michael,Thank you for a tip. I do need to convert single server to Postgres cluster HA and add another node (server), can I use this tool?
Bach-Nga
No one in this world is pure and perfect. If you avoid people for their mistakes you will be alone. So judge less, love and forgive more.To call him a dog hardly seems to do him justice though in as much as he had four legs, a tail, and barked, I admit he was, to all outward appearances. But to those who knew him well, he was a perfect gentleman (Hermione Gingold)
**Live simply **Love generously **Care deeply **Speak kindly.*** Genuinely rich *** Faithful talent *** Sharing success
On Thursday, November 14, 2019, 08:56:34 AM EST, Michael Banck <michael.banck@credativ.de> wrote:
Hi Ebin,
On Thu, Nov 14, 2019 at 07:15:45PM +0530, Ebin Jozer wrote:
> Thanks Ahmed. Is this open source and any support we can get?
Yes it is, you can get it at https://github.com/zalando/patroni/
Several Postgres consulting/support companies support Patroni.
Michael
--
Michael Banck
Projektleiter / Senior Berater
Tel.: +49 2166 9901-171
Fax: +49 2166 9901-100
Email: michael.banck@credativ.de
credativ GmbH, HRB Mönchengladbach 12080
USt-ID-Nummer: DE204566209
Trompeterallee 108, 41189 Mönchengladbach
Geschäftsführung: Dr. Michael Meskes, Jörg Folz, Sascha Heuer
Unser Umgang mit personenbezogenen Daten unterliegt
folgenden Bestimmungen: https://www.credativ.de/datenschutz
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Postgres cluster HA
2019-11-14 12:21 Postgres cluster HA Ebin Jozer <ebinjozer@gmail.com>
2019-11-14 13:15 ` RE: Postgres cluster HA ahmed.eljami@orange.com
2019-11-14 13:45 ` Re: Postgres cluster HA Ebin Jozer <ebinjozer@gmail.com>
2019-11-14 13:53 ` Re: Postgres cluster HA Michael Banck <michael.banck@credativ.de>
2019-11-14 14:03 ` Re: Postgres cluster HA Pepe TD Vo <pepevo@yahoo.com>
@ 2019-12-24 13:27 ` Amine Tengilimoglu <aminetengilimoglu@gmail.com>
0 siblings, 0 replies; 6+ messages in thread
From: Amine Tengilimoglu @ 2019-12-24 13:27 UTC (permalink / raw)
To: Pepe TD Vo <pepevo@yahoo.com>; Ebin Jozer <ebinjozer@gmail.com>; +Cc: Michael Banck <michael.banck@credativ.de>; ahmed.eljami@orange.com; pgsql-admin@lists.postgresql.org
Hi ;
You can use the BFM that was developed by BiSoft. It is platform
independent (Linux - Windows ).
BFM can manage failover between database servers located in any
geographic region. It is not based on virtual ip. It has the BIOXY.
With BIOXY the end users continue on their way without being affected by
master change. And also BIOXY can auditing the database conenction.
BFM has GUI. You can add or remove a node on the cluster easily. You can
get support from BiSoft (info@bisoft.com.tr).
Pepe TD Vo <pepevo@yahoo.com>, 14 Kas 2019 Per, 17:03 tarihinde şunu yazdı:
> Michael,
> Thank you for a tip.
> I do need to convert single server to Postgres cluster HA and add another
> node (server), can I use this tool?
>
>
>
> *Bach-Nga*No one in this world is pure and perfect. If you avoid people
> for their mistakes you will be alone. So judge less, love and forgive more.
> To call him a dog hardly seems to do him justice though in as much as he
> had four legs, a tail, and barked, I admit he was, to all outward
> appearances. But to those who knew him well, he was a perfect gentleman
> (Hermione Gingold)
>
> **Live simply **Love generously **Care deeply **Speak kindly.
> *** Genuinely rich *** Faithful talent *** Sharing success
>
>
> On Thursday, November 14, 2019, 08:56:34 AM EST, Michael Banck <
> michael.banck@credativ.de> wrote:
>
>
> Hi Ebin,
>
> On Thu, Nov 14, 2019 at 07:15:45PM +0530, Ebin Jozer wrote:
> > Thanks Ahmed. Is this open source and any support we can get?
>
> Yes it is, you can get it at https://github.com/zalando/patroni/
>
> Several Postgres consulting/support companies support Patroni.
>
>
> Michael
>
> --
> Michael Banck
> Projektleiter / Senior Berater
> Tel.: +49 2166 9901-171
> Fax: +49 2166 9901-100
> Email: michael.banck@credativ.de
>
> credativ GmbH, HRB Mönchengladbach 12080
> USt-ID-Nummer: DE204566209
> Trompeterallee 108, 41189 Mönchengladbach
> Geschäftsführung: Dr. Michael Meskes, Jörg Folz, Sascha Heuer
>
> Unser Umgang mit personenbezogenen Daten unterliegt
> folgenden Bestimmungen: https://www.credativ.de/datenschutz
>
>
>
>
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2019-12-24 13:27 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2019-11-14 12:21 Postgres cluster HA Ebin Jozer <ebinjozer@gmail.com>
2019-11-14 13:15 ` ahmed.eljami@orange.com
2019-11-14 13:45 ` Ebin Jozer <ebinjozer@gmail.com>
2019-11-14 13:53 ` Michael Banck <michael.banck@credativ.de>
2019-11-14 14:03 ` Pepe TD Vo <pepevo@yahoo.com>
2019-12-24 13:27 ` Amine Tengilimoglu <aminetengilimoglu@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox