Re: Installing Contrib Modules with a Precompiled Binary

From: Dave Page <dpage(at)pgadmin(dot)org>
To: Aram Fingal <fingal(at)multifactorial(dot)com>
Cc: Postgres-General General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Installing Contrib Modules with a Precompiled Binary
Date: 2010-09-20 19:38:37
Message-ID: AANLkTi=DKqRbCdj5bbGnzR_6ZVGVUKRuJdiqrQ+MkVLA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Sep 20, 2010 at 8:20 PM, Aram Fingal <fingal(at)multifactorial(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bryan Murphy 2010-09-20 19:53:12 Re: pgpool-II 3.0 + postgres 9rc1 + md5 authentication not working
Previous Message Dmitriy Igrishin 2010-09-20 19:34:59 Re: INSERT with SELECT not working in pgAdmin