postgresql data transfer from 9.3 to 9.4

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

Responses

Browse pgsql-bugs by date

  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