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
