From: | 許耀彰 <kpm906(at)gmail(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | postgresql data transfer from 9.3 to 9.4 |
Date: | 2018-02-11 08:28:18 |
Message-ID: | CAD_D-c9eL0xVqA165_zqpvCBf7c219VNG02atfLGDpeeVmiOww@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
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
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
不含病毒。www.avast.com
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
Attachment | Content-Type | Size |
---|---|---|
![]() |
image/png | 4.7 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | PG Bug reporting form | 2018-02-11 08:31:10 | BUG #15058: postgresql transfer from 9.3 to 9.4 |
Previous Message | Thomas Munro | 2018-02-11 02:27:30 | Re: BUG #15036: Un-killable queries Hanging in BgWorkerShutdown |