Upgraded to Ubuntu 12.04 from 10.04 and have to transfer database from Postgresql 8.4 to 9.1
Posted
by
Stpn
on Server Fault
See other posts from Server Fault
or by Stpn
Published on 2012-07-02T21:03:38Z
Indexed on
2012/07/02
21:17 UTC
Read the original article
Hit count: 247
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?
© Server Fault or respective owner