Nagios Support Forum

It looks like the postgresql fail to start up. I don't know if we are using postgresql.



[root@nms init.d]# systemctl status postgresql.service
postgresql.service - PostgreSQL database server
Loaded: loaded (/usr/lib/systemd/system/postgresql.service; enabled)
Active: failed (Result: exit-code) since Wed 2003-12-31 20:28:17 EST; 11 years 9 months ago
Process: 1385 ExecStart=/usr/bin/pg_ctl start -D ${PGDATA} -s -o -p ${PGPORT} -w -t 300 (code=exited, status=1/FAILURE)
Process: 1264 ExecStartPre=/usr/bin/postgresql-check-db-dir ${PGDATA} (code=exited, status=0/SUCCESS)

Dec 31 20:28:17 nms.galco.com systemd[1]: Starting PostgreSQL database server...
Dec 31 20:28:17 nms.galco.com pg_ctl[1385]: pg_ctl: another server might be running; trying to start server anyway
Dec 31 20:28:17 nms.galco.com pg_ctl[1385]: pg_ctl: could not start server
Dec 31 20:28:17 nms.galco.com pg_ctl[1385]: Examine the log output.
Dec 31 20:28:17 nms.galco.com systemd[1]: postgresql.service: control process exited, code=exited status=1
Dec 31 20:28:17 nms.galco.com systemd[1]: Failed to start PostgreSQL database server.
Dec 31 20:28:17 nms.galco.com systemd[1]: Unit postgresql.service entered failed state.
[root@nms init.d]# systemctl status mariadb.service
mariadb.service - MariaDB database server
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled)
Active: active (running) since Fri 2015-10-30 13:31:26 EDT; 1h 6min ago
Process: 6681 ExecStartPost=/usr/libexec/mariadb-wait-ready $MAINPID (code=exited, status=0/SUCCESS)
Process: 6652 ExecStartPre=/usr/libexec/mariadb-prepare-db-dir %n (code=exited, status=0/SUCCESS)
Main PID: 6680 (mysqld_safe)
CGroup: /system.slice/mariadb.service
ââ6680 /bin/sh /usr/bin/mysqld_safe --basedir=/usr
ââ6837 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --log-error=/var/log/mariadb/mariadb.log --pid-fil...

Oct 30 13:31:25 nms.galco.com mysqld_safe[6680]: 151030 13:31:25 mysqld_safe Logging to '/var/log/mariadb/mariadb.log'.
Oct 30 13:31:25 nms.galco.com mysqld_safe[6680]: 151030 13:31:25 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
Oct 30 13:31:26 nms.galco.com systemd[1]: Started MariaDB database server.

[root@nms init.d]# systemctl stop postgresql.service
[root@nms init.d]# systemctl start postgresql.service
[root@nms init.d]# systemctl status postgresql.service

postgresql.service - PostgreSQL database server
Loaded: loaded (/usr/lib/systemd/system/postgresql.service; enabled)
Active: active (running) since Fri 2015-10-30 14:40:58 EDT; 4s ago
Process: 8947 ExecStart=/usr/bin/pg_ctl start -D ${PGDATA} -s -o -p ${PGPORT} -w -t 300 (code=exited, status=0/SUCCESS)
Process: 8935 ExecStartPre=/usr/bin/postgresql-check-db-dir ${PGDATA} (code=exited, status=0/SUCCESS)
Main PID: 8988 (postgres)
CGroup: /system.slice/postgresql.service
ââ8988 /usr/bin/postgres -D /var/lib/pgsql/data -p 5432
ââ8989 postgres: logger process
ââ9024 postgres: checkpointer process
ââ9025 postgres: writer process
ââ9026 postgres: wal writer process
ââ9027 postgres: autovacuum launcher process
ââ9028 postgres: stats collector process
ââ9448 postgres: nagiosxi nagiosxi ::1(37074) idle
ââ9449 postgres: nagiosxi nagiosxi ::1(37075) idle
ââ9486 postgres: nagiosxi nagiosxi ::1(37076) idle
ââ9487 postgres: nagiosxi nagiosxi ::1(37077) idle
ââ9488 postgres: nagiosxi nagiosxi ::1(37078) idle
ââ9489 postgres: nagiosxi nagiosxi ::1(37079) idle
ââ9490 postgres: nagiosxi nagiosxi ::1(37080) startup
ââ9491 postgres: nagiosxi nagiosxi ::1(37081) startup

Oct 30 14:40:56 nms.galco.com pg_ctl[8947]: pg_ctl: another server might be running; trying to start server anyway
Oct 30 14:40:58 nms.galco.com systemd[1]: Started PostgreSQL database server.

galcoit wrote:Active: active (running) since Fri 2015-10-30 14:40:58 EDT; 4s ago

So after restarting can you log in?

Yes, I am now able to login.
So, the postgres database did not start correctly. Restart it resolve my problem.

thank you.

Y

Glad we could help! Are we all good to close this thread now?