I want to upgrade my PostgreSQL from version 8.4 to 9.4.
The documentation is not very clear to me.
- Will I lose my old databases if I do the upgrade?
- How can I backup my old databases if I am to lose them after the upgrade?
- How can I upgrade my psql?
My PostgreSQL is running on a CentOS 6.6 server.
Best Answer
This is how I solved my problem.
Upgrade Postgresql 8.4 to 9.4 in Centos
Backup Data
Restore Data
Config Network Access
vi /var/lib/pgsql/9.4/data/postgresql.conf
/var/lib/pgsql/9.4/data/pg_hba.conf
Remove PG8.4