Skip site navigation (1) Skip section navigation (2)

Re: -HEAD pg_dumpall broken against older backends

From: Stefan Kaltenbrunner <stefan(at)kaltenbrunner(dot)cc>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: pgsql-patches(at)postgresql(dot)org
Subject: Re: -HEAD pg_dumpall broken against older backends
Date: 2006-03-29 17:58:37
Message-ID: 442ACACD.9050103@kaltenbrunner.cc (view raw or flat)
Thread:
Lists: pgsql-patches
Peter Eisentraut wrote:
> Stefan Kaltenbrunner wrote:
> 
>>looks like somebody forgot to test some changes to the pg_dumpall
>>code in Revision 1.70 against <8.1 installations -  resulting in the
>>following syntax error:
> 
> 
> Dump output is never expected to be backward compatible.

yeah - but if you take a look at the code/patch you will see that the
problem in this case is that pg_dumpall generates invalid SQL if it is
operating against an older backend which is an obvious typo/thinko in
this case.
It has nothing to do with generating backwards compatible dumps - and
using the pg_dumpall from the (newer) target version for upgrades has
been recommended for a while (or rather is documented to work in the
manual) I think.


Stefan

In response to

pgsql-patches by date

Next:From: David FetterDate: 2006-03-29 20:24:51
Subject: Win32 sysconfig -> pg_service.conf
Previous:From: Andrew DunstanDate: 2006-03-29 17:48:13
Subject: Re: -HEAD pg_dumpall broken against older backends

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group