Nagios Support Forum

Hi Nagios Team,

Until last week, Nagios XI which I am running using the VMware was working well, but today when i tried to login, I got the following error:
DB Connect Error [nagiosxi]: Database connection failed DB Connect Error [nagiosxi]: Database connection failed DB Connect Error [nagiosxi]: Database connection failed

Then, I tried searching for solution in this forum, but suggestions were asked to check if mysql and postgresql was running.
After checking these in my case, mysql seems to be running by postgresql failed to start. It stopped, but failed to start the service.
And I tried running the suggested command: df -h
I have attached the output here, but it doesn't seem to be hard disk issue. Please help! Thanks in advance!

Try to start the postgresql service, post the output here (looking for more information):

Okay, I have tried the command given and attached here is the output.

Have you tried starting Postgres with either of the commands shown in your picture? Can you also try the following "slight change":

The following shows the output of the tail -50 /var/lib/pgsql/pgstartup.log And I tried one of the command shown on the picture but it shoots me error as in the figure attached here. When i tried to connecting it using psql command line tool, it threw me the following error.

Let's also do a "df -i" to check inodes since this has been a little bit. Additionally, did anything aside from this happen to your server? Such as power failures or disk issues? It seems that each time you start postgres it is starting for the very first time, initializing everything as though it was new.

There was no issue on the server, we just had to restart the server last week.
And I tried 'df -i' command, following shows the output.

When you restarted the server, was this done via power button or vmware restart action, or the actual shutdown -r\restart command in linux?

Run the following commands, and show the output:
Can you log in postgres by running the following command?