Re: multiple configurations with repmgr

El 8/1/19 a las 13:17, ROS Didier escribió:
> 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.

Yes, you can accomplish that following the instructions below for
configuring the witness:

- Initialize the postgres server on the witness node
- Create one database for each cluster the witness will be managing
- Create the appropriate repmgr.conf files, one for each cluster managed
through this witness, and each with the appropriate conninfo setting so
they point to different databases.
- Run `repmgr witness register` multiple times, using different
configuration files on each run

Hope that helps clarify.

P.S.: This works on latest versions of repmgr. Before 3.3 the witness
was created through repmgr which made things harder to manage, reason
why that was removed in later versions

Cheers,

--
Martín Marqués http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services