4.6. repmgr database user permissions

repmgr will create an extension database containing objects for administering repmgr metadata. The user defined in the conninfo setting must be able to access all objects. Additionally, superuser permissions are required to install the repmgr extension. The easiest way to do this is create the repmgr user as a superuser, however if this is not desirable, the repmgr user can be created as a normal user and a superuser specified with --superuser when registering a repmgr node.