I upgraded a server with a Rails application to Ubuntu 12.04 from 10.04 and cannot connect to
Postgresql database now...
Here is the error message from Rails app:
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"
pg_ctl start is not recognized as a command.
Turns out my database is on
Postgresl 8.4 and my sever is now running on 9.1. So all the database files / configs are on 8.4..
How can I transfer them? Just straight copy from old