I have a problem with postgresql as below: I have a server CentOS 5.9 install postgresql 8.4. It is running for my production and Data Size = 300 GB. At the moment, I need migrate all data in postgresql 8.4 to postgresql 9.4 in different server CentOS 6.6. I use method dumpall data from postgresql 8.4 and restore to postgres 9.4 but the downtime is very long and I canceled this method. Can you help me guide the method to migrate data in my case to the downtime is shortest?

Thanks you very much.


Migration plan:

1) Upgrade your PG on production server. For fast upgrade use pg_upgrade with -k option (WARNING!!! Read manual http://www.postgresql.org/docs/9.4/static/pgupgrade.html)

2) After upgrade PG setup replication from prod to new server.

3) Promote replica as new PG.


  • How to replicate data from postgresql 8.4 to postgresql 9.4 Alexander Vasylev? – Phong Đặng Apr 19 '15 at 6:54
  • Upgrade first (see 1 step above). – Alexander Vasylev Apr 19 '15 at 8:35

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.