Thread: postgresql downgrade issue
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.
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.
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安全提 示：本邮件非QUNAR内部邮件，请注意保护个人及公司信息安全，如有索取帐号密码等可疑情况请向 secteam发送邮件
-- ---------------------- 张文升
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
On Fri, Nov 13, 2015 at 10:44:07AM +0800, å¼ æå wrote: > 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. The original poster was not CC'ed on the reply, so I have added him/her. --------------------------------------------------------------------------- > > > > 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 > > > å®å ¨æ示ï¼æ¬é®ä»¶éQUNARå é¨é®ä»¶ï¼è¯·æ³¨æä¿æ¤ä¸ªäººåå ¬å¸ä¿¡æ¯å®å ¨ï¼å¦æç´¢åå¸å· > å¯ç çå¯çæ åµè¯·å secteamåéé®ä»¶ > > > -- > ---------------------- > å¼ æå > -- Bruce Momjian <bruce@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + As you are, so once was I. As I am, so you will be. + + Roman grave inscription +
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