Postgres Pro
Downloads
Home   >   mailing lists

Thread: Should I drop / create extensions after upgraging?

Should I drop / create extensions after upgraging?

From
François Beausoleil
Date:
Hello all!

I'm on Ubuntu 11.10, using 9.1.4. There was a new package for 9.1.5, and I just finished my upgrade. I make use of the
uuid-osspand tablefunc extensions. What is the expected upgrade procedure for these extensions? A drop followed by a
create?Or is there something else less invasive? 

I can't find any references to upgrades on http://www.postgresql.org/docs/9.1/static/sql-createextension.html, nor on
http://wiki.postgresql.org/wiki/ExtensionPackaging.Where should I have looked to find a reference to upgrading? 

Thanks!
François Beausoleil

Re: Should I drop / create extensions after upgraging?

From
"Tomas Vondra"
Date:
On 23 Srpen 2012, 18:19, François Beausoleil wrote:
> Hello all!
>
> I'm on Ubuntu 11.10, using 9.1.4. There was a new package for 9.1.5, and I
> just finished my upgrade. I make use of the uuid-ossp and tablefunc
> extensions. What is the expected upgrade procedure for these extensions? A
> drop followed by a create? Or is there something else less invasive?
>
> I can't find any references to upgrades on
> http://www.postgresql.org/docs/9.1/static/sql-createextension.html, nor on
> http://wiki.postgresql.org/wiki/ExtensionPackaging. Where should I have
> looked to find a reference to upgrading?

The minor updates (e.g. from 9.1.4 to 9.1.5) are a drop-in binary
replacements. You don't need to do anything special about the extensions,
it just works (unless there's something really broken).

Tomas

Re: Should I drop / create extensions after upgraging?

From
Tom Lane
Date:
"Tomas Vondra" <tv@fuzzy.cz> writes:
> On 23 Srpen 2012, 18:19, François Beausoleil wrote:
>> I'm on Ubuntu 11.10, using 9.1.4. There was a new package for 9.1.5, and I
>> just finished my upgrade. I make use of the uuid-ossp and tablefunc
>> extensions. What is the expected upgrade procedure for these extensions? A
>> drop followed by a create? Or is there something else less invasive?

> The minor updates (e.g. from 9.1.4 to 9.1.5) are a drop-in binary
> replacements. You don't need to do anything special about the extensions,
> it just works (unless there's something really broken).

Or perhaps more to the point: if there were something special you had to
do, the release notes for 9.1.5 would have told you about it.

            regards, tom lane