Re: Access Problem After Version Upgrade - Mailing list pgsql-general

From Tom Lane
Subject Re: Access Problem After Version Upgrade
Date
Msg-id 19754.1138295644@sss.pgh.pa.us
Whole thread Raw
In response to Access Problem After Version Upgrade  (Rich Shepard <rshepard@appl-ecosys.com>)
Responses Re: Access Problem After Version Upgrade
List pgsql-general
Rich Shepard <rshepard@appl-ecosys.com> writes:
> Now, I don't know that the server is accepting connections, but
> srwxr-xr-x  1 root root 0 2006-01-21 14:53 /tmp/.s.PGSQL.5432=
> exists as a socket.

>    What do I do to trace the source of this problem and fix it?

That's got the wrong ownership (should be postgres not root) and
the wrong permissions (should be world-writable).  Did somebody
do something silly like chown everything in /tmp?

You could manually fix the socket file's ownership and permissions,
or just remove it and restart the postmaster.

            regards, tom lane

pgsql-general by date:

Previous
From: Rich Shepard
Date:
Subject: Re: Access Problem After Version Upgrade
Next
From: Doug McNaught
Date:
Subject: Re: Access Problem After Version Upgrade -- Update