Is PostgreSQL server is running and accepting  and issue with “/var/pgsql_socket/.s.PGSQL.5432”?

The problem i got after upgrading to 9.3 i installed EDB edition and also through apt-get/synaptic manager

so was getting an error message
could not connect to server: Permission denied

    Is the server running locally and accepting

    connections on Unix domain socket “/var/pgsql_socket/.s.PGSQL.5432”?
This is how I solved that error message, 

find / -name .s.PGSQL.5432 -ls 2> /dev/null

 This resulted in /tmp/.s.PGSQL.5432

So, there’s my socket or whatever, but the client looks for it at:
/var/run/postgresql/.s.PGSQL.5432

So quite simply make a symbolic link to the /tmp/.s.PGSQL.5432:
sudo ln -s /tmp/.s.PGSQL.5432 /var/run/postgresql/.s.PGSQL.5432

Hope this helps to anyone. The seems kind of wrong, but hey, it works! Thanks to Frans 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s