Re: Post-Reboot Issue: Postmaster Not Accessible

On Wednesday 28 February 2007 08:12, Rich Shepard <rshepard@appl-ecosys.com>
wrote:

> [rshepard@salmo ~]$ psql -h localhost -U postgres aesi
> Welcome to psql 8.1.4, the PostgreSQL interactive terminal.
>
> Type:  \copyright for distribution terms
>         \h for help with SQL commands
>         \? for help with psql commands
>         \g or terminate with semicolon to execute query
>         \q to quit
>
> aesi=# \q
> [rshepard@salmo ~]$ psql aesi
> psql: could not connect to server: Connection refused
>          Is the server running locally and accepting
>          connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
>

Something happened to your /tmp directory after PostgreSQL started up.

Stop the postmaster, clean out the socket in /tmp, and restart the
postmaster, and it will likely fix it up.  Then you can investigate your
boot process to see what's going wrong.

--
"Remember when computers were frustrating because they did exactly what
you told them to?  That actually seems sort of quaint now." --J.D. Baldwin