Re: Access Problem After Version Upgrade

On 1/26/06 11:53 AM, "Rich Shepard" <rshepard(at)appl-ecosys(dot)com> wrote:

> Last week I upgraded from -7.4.3 to -8.1.2. I had some problems moving data
> because of both my ignorance of the proper syntax and the move from
> /usr/local/pgsql to /var/lib/pgsql. Now I cannot access the server:
>
> [rshepard(at)salmo ~]$ psql -l
> psql: could not connect to server: Permission denied
> Is the server running locally and accepting
> connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
>
> This also prevents me from logging in to SQL-Ledger and other applications.
> 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?

You did start the server? Did you fix the pg_hba.conf file? Does your
postgresql.conf file allow tcp connections? Those are the places I would
look.

Sean