Re: postgresql downgrade issue

On 12 November 2015 at 21:44, =E5=BC=A0=E6=96=87=E5=8D=87 <wensheng.zhang@q=
unar.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 origin=
al
>> 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