Re: postgresql downgrade issue

On 12 November 2015 at 21:59, Jaime Casanova
<jaime(dot)casanova(at)2ndquadrant(dot)com> wrote:
> 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