Upgraded to Ubuntu 12.04 from 10.04 and have to transfer database from Postgresql 8.4 to 9.1
- by Stpn
I upgraded 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"
Also the pg_ctl start is not recognized as a command..
EDIT:
Turns out my database in 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 pg_hba.conf?