Fixing Connection Issues After Installing PostgreSQL 9.4 and Uninstalling 9.3

postgresqlpostgresql-9.3postgresql-9.4

I have installed postgresql 9.4 and I removed postgresql 9.3 from my computer. Now when I try to run:

foo@bar:~$ psql

I get the error

psql: could not connect to server: No such file or directory
    Is the server running locally and accepting
    connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?

Note:

foo@bar:~$ psql --version
psql (PostgreSQL) 9.4.2

Best Answer

I resolve the problem changin the port from 5433 to 5432

Related Solutions

Postgresql – Can’t run PostgreSQL locally

If you have installed postgresql with brew there's one createdb that comes with it and that will connect to brew's postgresql.

Then if you have also installed Postgres.app there's another createdb at a different location that will connect to Postgres.app's postgresql.

Since OS X also ships with its own createdb in /usr/bin, that's a third createdb that expects to connect to Apple's postgresql, which is not running unless it's OS X Server Edition. According to the error message, this is the one that you're trying to use and which fails.

The solution is to use the createdb command that comes with the PostgreSQL you're actually running. Locate its directory and type the full path of createdb, as in /Applications/Postgres.app/Contents/MacOS/bin/createdb, and/or change your $PATH as suggested in postgresapp's doc.

This is a common problem for PostgreSQL on Mac OS X due the existence of many concurrent packages and of client-side programs pre-installed by Apple.

Postgresql – Can’t connect to local Postgres databases

If you want to run more postgres clusters on a single machine, just make sure that they have their own $PGDATA (the location where their data and config files are) and make sure that in their postgres.conf the parameter for port differ.

port = 2345
listen_addresses='*'

the cluster can share the listen_addresses but not the port. So each must have it's own port number.

Best Answer

Related Solutions

Postgresql – Can’t run PostgreSQL locally

Postgresql – Can’t connect to local Postgres databases

Related Question