Обсуждение: BUG #15058: postgresql transfer from 9.3 to 9.4

The following bug has been logged on the website:

Bug reference:      15058
Logged by:          耀彰 許
Email address:      kpm906@hotmail.com
PostgreSQL version: 9.3.0
Operating system:   ubuntu
Description:

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.(https://ithelp.ithome.com.tw/upload/images/20180209/200037053x0ai05gYR.png)
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

On Sun, Feb 11, 2018 at 08:31:10AM +0000, PG Bug reporting form wrote:
> PostgreSQL version: 9.3.0

If you are really using 9.3.0, you should consider an update to the
latest minor version in this series, which is 9.3.21 and which has been
released last Thursday.

> But at the transfer process, it showed the error message as shown as the
> attachment.(https://ithelp.ithome.com.tw/upload/images/20180209/200037053x0ai05gYR.png)
> 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

Without seeing a self-contained test case or more details about what you
are seeing, it is going to be impossible to give more details about what
is happening.  When doing an upgrade with a dump/restore method, please
make at least sure that the version of pg_dump doing the dump is the one
of the version you are upgrading to.
--
Michael