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