I have upgraded my ubuntu development machine from 11.04 to 11.10. In the process my postgres was also upgraded from 8.4 to 9.1.
But I seem to have lost all my data. If I look, I can see that my data for 8.4 is in folder /var/lib/postgres/8.4/main
and my new database is in /var/lib/postgres/9.1/main
.
What is the best way to migrate my data to the new version? Can I just copy the files?