Nagios Support Forum

Code: Select all

Backing up PostgresQL databases...
pg_dump: [archiver (db)] connection to database "nagiosxi" failed: 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"?

Code: Select all

service postgresql status
 ls /tmp/.*lock

Code: Select all

[root@LkennagiosP01 ~]# ls /tmp/.*lock                                          ls: cannot access /tmp/.*lock: No such file or directory
[root@LkennagiosP01 ~]#

Code: Select all

service postgresql restart

Code: Select all

service postgresql stop
killall postgresql
service postgres start

Code: Select all

tail -25 /var/lib/pgsql/pgstartup.log

Code: Select all

[root@LkennagiosP01 ~]# service postgresql stop
Stopping postgresql service:                               [  OK  ]
[root@LkennagiosP01 ~]# killall postgresql
postgresql: no process killed
[root@LkennagiosP01 ~]# service postgres start
postgres: unrecognized service
[root@LkennagiosP01 ~]# service postgresql start
Starting postgresql service:                               [  OK  ]
[root@LkennagiosP01 ~]# tail -25 /var/lib/pgsql/pgstartup.log

fixing permissions on existing directory /var/lib/pgsql/data ... ok
creating subdirectories ... ok
selecting default max_connections ... 100
selecting default shared_buffers ... 32MB
creating configuration files ... ok
creating template1 database in /var/lib/pgsql/data/base/1 ... ok
initializing pg_authid ... ok
initializing dependencies ... ok
creating system views ... ok
loading system objects' descriptions ... ok
creating conversions ... ok
creating dictionaries ... ok
setting privileges on built-in objects ... ok
creating information schema ... ok
vacuuming database template1 ... ok
copying template1 to template0 ... ok
copying template1 to postgres ... ok

Success. You can now start the database server using:

    /usr/bin/postgres -D /var/lib/pgsql/data
or
    /usr/bin/pg_ctl -D /var/lib/pgsql/data -l logfile start