4.7. repmgr database user permissions

repmgr requires that the database defined in the conninfo setting contains the repmgr extension. The database user defined in the conninfo setting must be able to access this database and the database objects contained within the extension.

The repmgr extension can only be installed by a superuser. If the repmgr user is a superuser, repmgr will create the extension automatically.

Alternatively, the extension can be created manually by a superuser (with "CREATE EXTENSION repmgr") before executing repmgr primary register.