Error upgrading to 2011R2.4

[itg-dac]

I get this error when i try to upgrade from 2011R2.3 to R2.4:

Code: Select all

# tar xzf xi-latest.tar.gz
# cd nagiosxi/
# ./upgrade
Checking PostgresQL status...
PostgresQL running - continuing...
Creating audit log database structure...
psql: could not connect to server: No such file or directory
        Is the server running locally and accepting
        connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
#

Any suggestion?

[scottwilkerson]

you might want to try restarting postgres

Code: Select all

service postgresql restart

[itg-dac]

Didnt work... suggestions ?

[mguthrie]

This is the actual command being run that is failing:

Code: Select all

psql -U nagiosxi nagiosxi <nagiosxi/auditlog.pgsql.sql >/dev/null

Did you update the postgresql credentials for the nagiosxi user, or put any special firewall rules in place that might explain the connection refusal? It's say that it can't connect to the local postgresql socket.