postgresql data transfer from 9.3 to 9.4

Hi

2018-02-11 9:28 GMT+01:00 許耀彰 <kpm906@gmail.com>:

Dear Support Team,
We face a question about migrating postgresql from 9.3 to 9.4. Because our
original postgresql is 9.3. And we use dump command to dump all record as
shown as below:
pg_dump dbname > outfile

At the same time , we update postgresql from 9.3 to .9.4 And then remove
9.3 postgresql. Finally we use command as listed as below to import all
record to 9.4 postgresql.
psql dbname < infile

But at the transfer process, it showed the error message as shown as the
attachment. How can we normally transfer 9.3 records to 9.4 postgresql in
the same server? Thanks for your kindly assistance.
Best Regards, Anderson Hsu

1. You should to use dump from target version, not from original. There is
not problem to have more installed version of postgresql client software
(pg_dump and other).

2. what you see is last error, you should to show first error

run:
psql -v ON_ERROR_STOP=1 dbname < infile

3. removing original release before successful migration is wrong

4. for these versions, you can migrate by faster pg_upgrade command

Regards

Pavel