Re: Post-Reboot Issue: Postmaster Not Accessible

Rich Shepard wrote:
> After having to reboot my server/workstation this morning, I've a
> problem with
> postgresql; one I've never before encountered.
>
> The postmaster is running:
>
> 9959 pts/1 S 0:00 /usr/bin/postmaster -D /var/lib/pgsql/data
>
> and the socket is present:
>
> srwxrwxrwx 1 root root 0 2007-02-28 05:20 /tmp/.s.PGSQL.5432=
>
> But I cannot connect to the database for SQL-Ledger nor from the command
> line:
>
> [rshepard(at)salmo ~]$ psql
> psql: could not connect to server: Connection refused
> Is the server running locally and accepting
> connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
>
> The server is running locally. How can I test whether it's accepting
> connections on the socket? And, what can I do to get it back to normal and
> accpting connections?

psql -h localhost -U postgres databasename

Joshua D. Drake

>
> Thanks,
>
> Rich
>

--

=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/