Page 1 of 1

Error upgrading to 2011R2.4

Posted: Mon Apr 30, 2012 6:57 am
by 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? :cry:

Re: Error upgrading to 2011R2.4

Posted: Mon Apr 30, 2012 9:25 am
by scottwilkerson
you might want to try restarting postgres

Code: Select all

service postgresql restart

Re: Error upgrading to 2011R2.4

Posted: Wed May 02, 2012 3:25 am
by itg-dac
Didnt work... suggestions ?

Re: Error upgrading to 2011R2.4

Posted: Wed May 02, 2012 9:35 am
by 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.