Re: BUG #1468: psql_dump is not backward compatible

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Tobias Brox <tobias(at)nordicbet(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #1468: psql_dump is not backward compatible
Date: 2005-02-09 22:42:38
Message-ID: 200502092242.j19Mgcu19503@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


Yea, we have never supported loading newer dumps into older servers. We
do support the opposite, though.

---------------------------------------------------------------------------

Tobias Brox wrote:
>
> The following bug has been logged online:
>
> Bug reference: 1468
> Logged by: Tobias Brox
> Email address: tobias(at)nordicbet(dot)com
> PostgreSQL version: 8.0.0
> Operating system: Linux, gentoo
> Description: psql_dump is not backward compatible
> Details:
>
> I have a situation where my peers is using PG 7.4.6, and they are pretty
> pissed off at me for using PG 8.0 - the DB dumps are incompatible. The
> command I use for generating the dump is "pg_dump -Oa NBET".
>
> I don't have version 7.4.6 installed myself, so I cannot reproduce this
> reliably on my own.
>
> We use serial primary keys, the problem reported by my peers is that PG
> 7.4.6 needs an "update sequence" on all the primary keys. The old data dump
> outputs lines on this form:
>
> SELECT pg_catalog.setval('user_group_id_seq', 5, False);
>
> PG 8.0 swallows the old data without problems, so I suppose it's needed with
> a switch for backword compatibility there.
>
> I tried pg_dump with the parameters "OaD" (make full "insert"-statements,
> should be compatible with anything), but this was rejected by my peers.
>
> I think the problem should be reproducable with the information above, if
> not I can try install PG 7.4.6
> to create some comparable dumps with PG 8.0 and PG 7.4.6.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Josh Berkus 2005-02-09 23:16:32 Index scans for unique index not visible in stats
Previous Message Tom Lane 2005-02-09 21:07:18 Re: BUG #1470: Boolean expression index not used when it could be