Re: Should I drop / create extensions after upgraging?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Tomas Vondra" <tv(at)fuzzy(dot)cz>
Cc: "François Beausoleil" <francois(at)teksol(dot)info>, "pgsql-general" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Should I drop / create extensions after upgraging?
Date: 2012-08-23 17:36:24
Message-ID: 606.1345743384@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Tomas Vondra" <tv(at)fuzzy(dot)cz> writes:
> On 23 Srpen 2012, 18:19, Franois 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message javad M 2012-08-23 18:10:11 Re: Cannot Run EnterpriseDB Postgresql Installation
Previous Message Tomas Vondra 2012-08-23 17:03:19 Re: Should I drop / create extensions after upgraging?