HostsVault BlogHostsVault Blog

You may face this situation where you need to migrate to a newer hardware/software server then find that your previous PostgreSQL version database is not compatible to the new 8.X version probably you have 7.X version here are the steps to migrate to this new version:

First on old server :

su - postgres
pg_dumpall > /tmp/db.out
exit

Then move the /tmp/db.out to the new server  on /tmp/db.out

On new server :

su - postgres
psql -f /tmp/db.out template1
exit

Once back as root :

service postgresql restart

Remember to erase or move /tmp/db.out  to somewhere not public , hope this helps anyone.