Re: Installing Contrib Modules with a Precompiled Binary - Mailing list pgsql-general

From Dave Page
Subject Re: Installing Contrib Modules with a Precompiled Binary
Date
Msg-id AANLkTi=DKqRbCdj5bbGnzR_6ZVGVUKRuJdiqrQ+MkVLA@mail.gmail.com
Whole thread Raw
In response to Re: Installing Contrib Modules with a Precompiled Binary  (Aram Fingal <fingal@multifactorial.com>)
List pgsql-general
On Mon, Sep 20, 2010 at 8:20 PM, Aram Fingal <fingal@multifactorial.com> wrote:
>
> So that means something like:
> psql -d dbname -f
> /Library/PostgreSQL/8.4/share/postgresql/contrib/tablefunc.sql

Yup.

> I suppose that I will have to export and re-import the databases when I
> upgrade?

Hmm, yes - interesting point. pg_upgrade won't work, because OSX will
automatically run the 64bit part of the Universal binaries with 9.0,
where the 8.3 or 8.4 versions would have been 32bit.

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise Postgres Company

pgsql-general by date:

Previous
From: Dmitriy Igrishin
Date:
Subject: Re: INSERT with SELECT not working in pgAdmin
Next
From: Bryan Murphy
Date:
Subject: Re: pgpool-II 3.0 + postgres 9rc1 + md5 authentication not working