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

Re: Ambiguos OPERATOR items in pg_restore manifest file

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: rkottman(at)mpi-bremen(dot)de
Cc: pgsql-bugs(at)postgresql(dot)org, PostGIS Development Discussion <postgis-devel(at)postgis(dot)refractions(dot)net>, Sebastian Groß <sgross(at)mpi-bremen(dot)de>
Subject: Re: Ambiguos OPERATOR items in pg_restore manifest file
Date: 2011-07-27 19:20:56
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
On Wed, Jul 20, 2011 at 8:24 AM, Renzo Kottmann <rkottman(at)mpi-bremen(dot)de> wrote:
> On 07/18/2011 05:25 PM, Robert Haas wrote:
>> On Tue, Jul 12, 2011 at 9:18 AM, Sandro Santilli <strk(at)keybit(dot)net> wrote:
>>> Trying to exclude items from dumps of postgis-enabled databases
>>> we use pg_restore -l output and strip what we think belong to PostGIS.
>>> In doing so, Renzo found that for OPERATOR there are not enough
>>> informations to unambiguosly find it being part of PostGIS (see
>>> included mail snippet).
>>> Do you think this could be improved on the pg_restore side ?
>> In 9.1, we've added the concept of EXTENSIONs.  I'm not sure whether
>> PostGIS is planning to take advantage of this mechanism, but it's
>> designed to solve exactly this problem.
> The extensions concept will be a big  step forward, no doubt.
> I just do not think that it solves the aforementioned problem. AFAIK
> the extension system will be available for 9.1 only. Then it would not
> be available for all kinds of dump/restore scenarios <9.1 (in my case
> from 8.4 to 9.0).

Yeah, that's a problem.  The mechanism does include some magic that's
supposed to help deal with this.  The idea is -- first, you upgrade to
9.1 -- next, you say something like CREATE EXTENSION ename FROM
unpackaged -- finally, you upgrade the extension using ALTER EXTENSION
UPDATE.  However, I'm not sure whether PostGIS is planning to support
this mechanism, or whether it meets their needs.

Robert Haas
The Enterprise PostgreSQL Company

In response to

pgsql-bugs by date

Next:From: Kurt MielkeDate: 2011-07-27 20:15:30
Subject: BUG #6133: -lpq frees unallocated memory on exit
Previous:From: John R PierceDate: 2011-07-27 18:30:10
Subject: Re: BUG #6132: Cannot install rpm files

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