Thread: 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