Upgrade 8.4 with contrib to 9.1

Started by Tarlika Elisabeth Schmitzover 14 years ago4 messagesgeneral
Jump to latest
#1Tarlika Elisabeth Schmitz
postgresql6@numerixtechnology.de

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

#2Scott Marlowe
scott.marlowe@gmail.com
In reply to: Tarlika Elisabeth Schmitz (#1)
Re: Upgrade 8.4 with contrib to 9.1

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?

#3John R Pierce
pierce@hogranch.com
In reply to: Tarlika Elisabeth Schmitz (#1)
Re: Upgrade 8.4 with contrib to 9.1

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]in 9.1, use CREATE EXTENSION hstore; to do this, rather than sourcing the .sql scripts.... I'm not familiar
with those others.

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

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

#4Tarlika Elisabeth Schmitz
postgresql6@numerixtechnology.de
In reply to: Scott Marlowe (#2)
Re: Upgrade 8.4 with contrib to 9.1

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