Did a DU today and Postgres 9.4 replaced 9.3. I started it with /etc/init.d/postgres start and ps -aux | grep postgres shows it's running:
root 4507 0.0 0.0 35400 944 pts/0 S+ 15:48 0:00 grep postgres
postgres 28402 0.0 0.2 246244 16220 ? Ss 15:44 0:00 /usr/lib/postgresql/9.4/bin/postgres -c config_file=/etc/postgresql/9.4/main/postgresql.conf
postgres 28410 0.0 0.0 246244 1844 ? Ss 15:44 0:00 postgres: checkpointer process
postgres 28411 0.0 0.0 246244 2644 ? Ss 15:44 0:00 postgres: writer process
postgres 28412 0.0 0.0 246244 1624 ? Ss 15:44 0:00 postgres: wal writer process
postgres 28413 0.0 0.0 246652 2604 ? Ss 15:44 0:00 postgres: autovacuum launcher process
postgres 28414 0.0 0.0 101388 1676 ? Ss 15:44 0:00 postgres: stats collector process
But when I try to access it with psql I get an error:
sql: 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"?
Anyone have any ideas?
In case anyone has trouble with this I had to solve this by editing
vi /etc/postgresql/9.4/main/postgresql.conf
and uncommenting the listen address
listen_addresses = 'localhost'
and also set the port to 5432 which is where postgres 9.3 was looking
port = 5432
I basically had to set everything up again after that the way I did for 9.3 (http://www.hackido.com/2014/04/setting-up-postgres-for-local.html) (password for postgres user, etc) but evenually got it working.