Data migration from postgres 8.4 to 9.4

From: Akshay Ballarpure <akshay(dot)ballarpure(at)tcs(dot)com>
To: undisclosed-recipients:;
Subject: Data migration from postgres 8.4 to 9.4
Date: 2018-04-16 07:03:12
Message-ID: OFC9006B3F.4ED1F955-ON65258271.0025E96C-65258271.0026910D@tcs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-performance

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(at)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(at)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(dot)ballarpure(at)tcs(dot)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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Amitabh Kant 2018-04-16 07:11:12 Re: Data migration from postgres 8.4 to 9.4
Previous Message Adrian Klaver 2018-04-16 04:08:53 Re: authentication failure

Browse pgsql-performance by date

  From Date Subject
Next Message Amitabh Kant 2018-04-16 07:11:12 Re: Data migration from postgres 8.4 to 9.4
Previous Message Ants Aasma 2018-04-13 09:55:03 Re: Latest advice on SSD?