Postgres account on Nagos xi

xlin125 · Post by **xlin125** » Fri Apr 30, 2021 1:28 pm

The Nagios xi 5.x or later only needs MySQL, and Postgres is no longer needed or installed. I do not think the postgres DB account "postgres" is used by Nagios xi 5.x at all. Please confirm it.

ssax · Post by **ssax** » Mon May 03, 2021 11:10 am

If you upgraded from a version less than xi 5, you will be using postgresql for the nagiosxi database. Which can be converted to mysql:

https://support.nagios.com/kb/article/c ... i-560.html

What is the output of this command on your system?

Code: Select all

grep pgsql /usr/local/nagiosxi/html/config.inc.php

xlin125 · Post by **xlin125** » Tue May 04, 2021 8:35 pm

Our Nagios xi 5.x was a fresh installation on a Linux (RHEL) server, not an upgraded from a version less than Nagios xi 5. As expected, running the command "grep pgsql /usr/local/nagiosxi/html/config.inc.php" returned no match:
$ grep pgsql /usr/local/nagiosxi/html/config.inc.php
$

Just wanted to clarify that the account "postgres" is a system (Linux/RHEL) account, not a Postgres DB account:
$ grep postgres /etc/passwd
postgres

26:26:PostgreSQL Server:/var/lib/pgsql:/bin/nologin

Post by **vtrac** » Wed May 05, 2021 11:27 am

Hi,
I checked against my xi 5.8.3 on CentOS 7.9 and yes, "postgres" is the OS system account.

Code: Select all

[root@VT-Nagiosxi-61 ~]# grep postgres /etc/passwd
postgres:x:26:26:PostgreSQL Server:/var/lib/pgsql:/bin/bash

I checked "ps -ef | grep postgres" and do not see any running process with that user.

If your is a fresh installed of xi 5.x, then I don't think the "postgres" user account is being used.

Best Regards,
Vinh

Nagios Support Forum

Postgres account on Nagos xi

Postgres account on Nagos xi

Re: Postgres account on Nagos xi

Re: Postgres account on Nagos xi

Re: Postgres account on Nagos xi