Hello, I need help in using postgresql 8.4 data in postgres 9.4 version. Do I need to run any tool to achieve the same?
Steps i followed is ran postgresql 8.4 and 9.4, copied data from 8.4 instance to 9.4 and try to start postgresql 9.4 but no luck, getting below error. [root@ms-esmon esm-data]# su - postgres -c "/opt/rh/rh-postgresql94/root/usr/bin/postgres -D /var/ericsson/esm-data/postgresql-data/ 2>&1 &" [root@ms-esmon esm-data]# LOG: skipping missing configuration file "/var/ericsson/esm-data/postgresql-data/postgresql.auto.conf" 2018-04-16 06:52:01.546 GMT FATAL: database files are incompatible with server 2018-04-16 06:52:01.546 GMT DETAIL: The data directory was initialized by PostgreSQL version 8.4, which is not compatible with this version 9.4.9. With Best Regards Akshay Ericsson OSS MON Tata Consultancy Services Mailto: akshay.ballarp...@tcs.com Website: http://www.tcs.com ____________________________________________ Experience certainty. IT Services Business Solutions Consulting ____________________________________________ =====-----=====-----===== Notice: The information contained in this e-mail message and/or attachments to it may contain confidential or privileged information. If you are not the intended recipient, any dissemination, use, review, distribution, printing or copying of the information contained in this e-mail message and/or attachments to it are strictly prohibited. If you have received this communication in error, please notify us by reply e-mail or telephone and immediately and permanently delete the message and any attachments. Thank you