0

I installed repmgr10 on PostgreSQL server before. But now will reinstall them.

Deleted postgresql's data folder: /var/lib/pgsql/10/data/.

Stoped postgresql-10 service: sudo systemctl stop postgresql-10.

Also did sudo systemctl stop repmgr10.

But check repmgr's status, got

$ sudo systemctl status repmgr10
● repmgr10.service - A replication manager, and failover management tool for PostgreSQL
   Loaded: loaded (/usr/lib/systemd/system/repmgr10.service; enabled; vendor preset: disabled)
   Active: failed (Result: exit-code) since Wed 2020-07-08 10:37:43 JST; 3h 7min ago
  Process: 250464 ExecStop=/usr/bin/kill -TERM $MAINPID (code=exited, status=0/SUCCESS)
  Process: 251422 ExecStart=/usr/pgsql-10/bin/repmgrd -f ${REPMGRDCONF} -p ${PIDFILE} -d --verbose (code=exited, status=1/FAILURE)
 Main PID: 152648 (code=exited, status=0/SUCCESS)

Jul 08 10:37:43 server_db systemd[1]: Starting A replication manager, and failover management tool for PostgreSQL...
Jul 08 10:37:43 server_db repmgrd[251422]: [2020-07-08 10:37:43] [NOTICE] using provided configuration file "/etc/repmgr/10/repmgr.conf"
Jul 08 10:37:43 server_db repmgrd[251422]: [2020-07-08 10:37:43] [NOTICE] redirecting logging output to "/var/log/repmgr/repmgr.log"
Jul 08 10:37:43 server_db systemd[1]: repmgr10.service: control process exited, code=exited status=1
Jul 08 10:37:43 server_db systemd[1]: Failed to start A replication manager, and failover management tool for PostgreSQL.
Jul 08 10:37:43 server_db systemd[1]: Unit repmgr10.service entered failed state.
Jul 08 10:37:43 server_db systemd[1]: repmgr10.service failed.
Hint: Some lines were ellipsized, use -l to show in full.

I checked log in the /var/log/repmgr/repmgr.log

[2020-07-08 10:24:18] [NOTICE] repmgrd (repmgrd 5.0.0) starting up
[2020-07-08 10:24:18] [ERROR] repmgr extension not found on this node
[2020-07-08 10:24:18] [DETAIL] repmgr extension is available but not installed in database "repmgr"
[2020-07-08 10:24:18] [HINT] check that this node is part of a repmgr cluster
[2020-07-08 10:37:43] [NOTICE] repmgrd (repmgrd 5.0.0) starting up
[2020-07-08 10:37:43] [ERROR] repmgr extension not found on this node
[2020-07-08 10:37:43] [DETAIL] repmgr extension is available but not installed in database "repmgr"
[2020-07-08 10:37:43] [HINT] check that this node is part of a repmgr cluste

It shown repmgr extension is available but not installed in database "repmgr".

But now repmgr service can't been restarted so how to install repmgr extension in database?

So I want to know how to stop repmgr daemon or remove this package then install again? That maybe can solve the problem.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.