Re: postgresql downgrade issue

On 12 November 2015 at 21:44, 张文升 <wensheng(dot)zhang(at)qunar(dot)com> wrote:
>> On 2015年11月12日 20:11, 許耀彰 wrote:
>>
>> Dear Support Team,
>> If we use ubuntu server to install postgresql9.4, how can we keep original
>> 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~~耀彰
>
> 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(at)postgresql(dot)org

--
Jaime Casanova www.2ndQuadrant.com
Professional PostgreSQL: Soporte 24x7 y capacitación