search

EnterpriseDB / repmgr

A lightweight replication manager for PostgreSQL (Postgres)
https://repmgr.org/
Other
1.58k stars 252 forks source link

Unable to start repmgr on boot my server. #794

Open wasiualhasib opened 1 year ago

wasiualhasib commented 1 year ago

Unable to start repmgr-15.service on boot. I am not sure why it is not started. As per service file it should start after postersql-15.service but it is not started. Somehow repmgr trying to connect before starting postgresql-15.service start. How can I solve this issue by passing delay on repmgr? All necessary command given at configuration file to start and stop repmgr and postgresql but where is the issue I could not understand. @ibarwick can you help me out on this issue?

[2023-02-06 02:04:19] [INFO] connecting to database "host=192.168.43.140 user=repmgr dbname=repmgr connect_timeout=6 port=5432"
[2023-02-06 02:04:19] [ERROR] connection to database failed
[2023-02-06 02:04:19] [DETAIL]
connection to server at "192.168.43.140", port 5432 failed: Network is unreachable
        Is the server running on that host and accepting TCP/IP connections?

[2023-02-06 02:04:19] [DETAIL] attempted to connect using:
  user=repmgr connect_timeout=6 dbname=repmgr host=192.168.43.140 port=5432 fallback_application_name=repmgr options=-csearch_path=
martinmarques commented 1 year ago

You need to look at the postgres logs to see why repmgr is not able to connect. I would also try starting postgres and then repmgr with systemctl and see the outcome. If there's a failure, check the logs.