Re: increasing HA

[Nicolas Karolak]

I have a setup kind of like yours, one primary and two stanby, but
with streaming replication.

Here is what i use:
-> on application (Django webapp) servers:
|---> a local HAProxy as a frontend for database servers, doing the
fencing through a check on a custom daemon running on database servers
-> on PostgreSQL servers:
|---> repmgr for the automatic failover
|---> the custom daemon which expose the state of the node (by trying
to retreive its state according to each node's repmgr status table and
doing a kind of vote, for exemple "if according to me i'm the primary
but not according to the two other nodes, i'm fenced")

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 mer. 5 sept. 2018 à 18:39, Dmitri Maziuk  a écrit :
>
> On Wed, 5 Sep 2018 17:45:05 +0200
> Thomas Poty  wrote:
>
> > We have one master and 2 slaves so 3 nodes
>
> So what is the "HA" that you're trying to "increase"? Are you adding a 3rd 
> slave? A 2nd master? A hot standby? All of the above?
>
> --
> Dmitri Maziuk 
>

Re: multiple configurations with repmgr

[Nicolas Karolak]

As far as i know, repmgr work at the "cluster" level so you would need
to run another postgres "cluster" instance (running on another port)
and another repmgrd instance (which would load a configuration
pointing to the new "cluster").

Regards,
Nicolas KAROLAK | Linux Systems Engineer
6-8, rue André Voguet - 94200 Ivry-sur-Seine
+33 1 77 56 77 96 | www.ubicast.eu | www.ubicast.tv

On Tue, Jan 8, 2019 at 5:17 PM ROS Didier  wrote:
>
> Hi
>
>We are going to use repmgr  with one node for the primary, one 
> node for the standby and one node for the witness.
>
>It works fine with one project.
>
>
>
> The problem is  that we want to have several other projects. Each one with 
> its own primary node, its own standby node and the same witness node.
>
>Question : is it possible to do that ? One witness node which 
> surveys several other nodes.
>
>
>
>Thanks in advance
>
>
>
> Best Regards
>
>
> Didier ROS
> Expertise SGBD
> DS IT/IT DMA/Solutions Groupe EDF/Expertise Applicative - SGBD
> Nanterre Picasso - E2 565D (aile nord-est)
> 32 Avenue Pablo Picasso
> 92000 Nanterre
>
>
>
>
>
>
> Ce message et toutes les pièces jointes (ci-après le 'Message') sont établis 
> à l'intention exclusive des destinataires et les informations qui y figurent 
> sont strictement confidentielles. Toute utilisation de ce Message non 
> conforme à sa destination, toute diffusion ou toute publication totale ou 
> partielle, est interdite sauf autorisation expresse.
>
> Si vous n'êtes pas le destinataire de ce Message, il vous est interdit de le 
> copier, de le faire suivre, de le divulguer ou d'en utiliser tout ou partie. 
> Si vous avez reçu ce Message par erreur, merci de le supprimer de votre 
> système, ainsi que toutes ses copies, et de n'en garder aucune trace sur 
> quelque support que ce soit. Nous vous remercions également d'en avertir 
> immédiatement l'expéditeur par retour du message.
>
> Il est impossible de garantir que les communications par messagerie 
> électronique arrivent en temps utile, sont sécurisées ou dénuées de toute 
> erreur ou virus.
> 
>
> This message and any attachments (the 'Message') are intended solely for the 
> addressees. The information contained in this Message is confidential. Any 
> use of information contained in this Message not in accord with its purpose, 
> any dissemination or disclosure, either whole or partial, is prohibited 
> except formal approval.
>
> If you are not the addressee, you may not copy, forward, disclose or use any 
> part of it. If you have received this message in error, please delete it and 
> all copies from your system and notify the sender immediately by return 
> message.
>
> E-mail communication cannot be guaranteed to be timely secure, error or 
> virus-free.