Ok, now the Centos service interface shows that the service has failed, due to some postmaster.pid lock file that the postmaster process uses, that's true, the file exists and the postmaster process is still running, the database cluster is still accessible. Oct 30 10:40:40 server systemd: rvice failed
Oct 30 10:40:40 server systemd: Unit rvice entered failed state. Oct 30 10:40:40 server systemd: Failed to start PostgreSQL 10 database server. Oct 30 10:40:40 server systemd: rvice: main process exited, code=exited, status=1/FAILURE Oct 30 10:40:40 server postmaster: 10:40:40.431 GMT HINT: Is another postmaster (PID 8545) running in data directory "/var/lib/pgsql/10/data"? You should never manually delete postmaster.pid. Oct 30 10:40:40 server postmaster: 10:40:40.431 GMT FATAL: lock file "postmaster.pid" already exists Oct 30 10:40:40 server systemd: Starting PostgreSQL 10 database server. Main PID: 19359 (code=exited, status=1/FAILURE) Process: 19359 ExecStart=/usr/pgsql-10/bin/postmaster -D $ (code=exited, status=0/SUCCESS) Loaded: loaded (/usr/lib/systemd/system/rvice enabled vendor preset: disabled)Īctive: failed (Result: exit-code) since mar 10:40:40 GMT 12min ago Although the server can be started manually, pgctl encapsulates tasks such as redirecting log output and properly detaching from the terminal and process group. Systemctl restart rvice didn't worked, when I execute systemctl status rvice this is shown: pgctl is a utility for starting, stopping, or restarting the PostgreSQL backend server ( postmaster ), or displaying the status of a running server.
Stale postmaster.pid file postgres app mac#
Well my intention was to change the wal_level in the configuration from replica to logical, so I did, I changed it in the nf and tried to restart the service as the instructions in the nf said. Sometimes when you mac shuts down unexpectedly while running a PostgreSQL database it can result in the following error: Stale postmaster.pid file. This Database is a Master and it has 1 stand_by replica acting as a mirror. Postgres 10 database running on a Centos RHEL 7.
0 kommentar(er)
