Re: postgresql downgrade issue - Mailing list pgsql-bugs

From Jaime Casanova
Subject Re: postgresql downgrade issue
Date
Msg-id CAJGNTePByq0g86Bz3wsHrWHn-4QsH423DhVaRwp5UPCiGzwvsA@mail.gmail.com
Whole thread Raw
In response to Re: postgresql downgrade issue  (Jaime Casanova <jaime.casanova@2ndquadrant.com>)
List pgsql-bugs
On 12 November 2015 at 21:59, Jaime Casanova
<jaime.casanova@2ndquadrant.com> wrote:
> On 12 November 2015 at 21:44, =E5=BC=A0=E6=96=87=E5=8D=87 <wensheng.zhang=
@qunar.com> wrote:
>>> On 2015=E5=B9=B411=E6=9C=8812=E6=97=A5 20:11, =E8=A8=B1=E8=80=80=E5=BD=
=B0 wrote:
>>>
>>> Dear Support Team,
>>> If we use ubuntu server to install postgresql9.4, how can we keep origi=
nal
>>> data to downgrade postgresql from 9.4 to 9.3. Would it be possible to
>>> support the guidance for us ? Thank you.
>>> Best Regards, Anderson Hsu
>>
>> hi~~=E8=80=80=E5=BD=B0
>>
>> you can  first dump data from pg9.4 use pg_dump and then restore data to
>> pg9.3 use pg_restore.
>> I hope this can help you.
>>
>>

Actually, he should use plain text format (pg_dump default) because
PostgreSQL doesn't support downgrade.
Btw, this is not a bug. Another mailing list should have been more
appropiate, for example: pgsql-general@postgresql.org

--=20
Jaime Casanova                      www.2ndQuadrant.com
Professional PostgreSQL: Soporte 24x7 y capacitaci=C3=B3n

pgsql-bugs by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: postgresql downgrade issue
Next
From: needthistool@gmail.com
Date:
Subject: BUG #13775: CREATE RULE documentation seems to be wrong under ON SELECT TO DO INSTEAD SELECT