Page 1 of 1
Postgres account on Nagos XI
Posted: Fri Apr 30, 2021 1:28 pm
by xlin125
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.
Re: Postgres account on Nagos XI
Posted: Mon May 03, 2021 11:10 am
by ssax
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
Re: Postgres account on Nagos XI
Posted: Tue May 04, 2021 8:35 pm
by xlin125
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
Re: Postgres account on Nagos XI
Posted: Wed May 05, 2021 11:27 am
by vtrac
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
26:26:PostgreSQL Server:/var/lib/pgsql:/bin/nologin