On 1/26/06 11:53 AM, "Rich Shepard" <rshepard@xxxxxxxxxxxxxxx> 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@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
