Postgres Pro
Downloads
Home   >   mailing lists

Thread: Upgrade 8.4 with contrib to 9.1

Upgrade 8.4 with contrib to 9.1

From
Tarlika Elisabeth Schmitz
Date:
Hello,
I am running 8.4 with various contrib modules (hstore-new, pg_trgm,
fuzzystrmatch).

If I wanted to upgrade to 9.1, can I / would I have to uninstall the
contrib modules?

Are there any incompatibilities between the contrib and corresponding
9.1 functions?
--

Best Regards,
Tarlika Elisabeth Schmitz

Re: Upgrade 8.4 with contrib to 9.1

From
Scott Marlowe
Date:
On Mon, Nov 14, 2011 at 11:12 AM, Tarlika Elisabeth Schmitz
<postgresql6@numerixtechnology.de> wrote:
> Hello,
> I am running 8.4 with various contrib modules (hstore-new, pg_trgm,
> fuzzystrmatch).
>
> If I wanted to upgrade to 9.1, can I / would I have to uninstall the
> contrib modules?
>
> Are there any incompatibilities between the contrib and corresponding
> 9.1 functions?

In the past full text search has needed the uninstall / install boogie
to work, not sure about 8.4 to 9.1 tho.

What contrib modules are you running?

Re: Upgrade 8.4 with contrib to 9.1

From
John R Pierce
Date:
On 11/14/11 10:12 AM, Tarlika Elisabeth Schmitz wrote:
> Hello,
> I am running 8.4 with various contrib modules (hstore-new, pg_trgm,
> fuzzystrmatch).
>
> If I wanted to upgrade to 9.1, can I / would I have to uninstall the
> contrib modules?
>
> Are there any incompatibilities between the contrib and corresponding
> 9.1 functions?

hstore in 9.x replaces hstore-new in 8.4, so you likely would want to
uninstall that first, then install the new hstore[1].   I'm not familiar
with those others.




[1] in 9.1, use CREATE EXTENSION hstore;  to do this, rather than
sourcing the .sql scripts...

--
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast

Re: Upgrade 8.4 with contrib to 9.1

From
Tarlika Elisabeth Schmitz
Date:
On Mon, 14 Nov 2011 14:20:39 -0700
Scott Marlowe <scott.marlowe@gmail.com> wrote:

>On Mon, Nov 14, 2011 at 11:12 AM, Tarlika Elisabeth Schmitz
><postgresql6@numerixtechnology.de> wrote:
>> I am running 8.4 with various contrib modules (hstore-new, pg_trgm,
>> fuzzystrmatch).
>>
>> If I wanted to upgrade to 9.1, can I / would I have to uninstall the
>> contrib modules?
>
>In the past full text search has needed the uninstall / install boogie
>to work, not sure about 8.4 to 9.1 tho.
>
>What contrib modules are you running?
>

hstore-new, pg_trgm, fuzzystrmatch


--

Best Regards,
Tarlika Elisabeth Schmitz