Thread: Enableing contrib modules on Debian

Hi,

I've installed the postgresql-contrib8.1 deb package to get at the
earthdistance function, but it doesn't seem to be recognised, even
after a restart of the server.

Is there a final step I need to take after using apt-get to install?

--
-S

Sports Photography in South Yorkshire & Derbyshire
http://www.stuartgrimshaw.co.uk

"Stuart Grimshaw" <stuart.grimshaw@gmail.com> writes:
> I've installed the postgresql-contrib8.1 deb package to get at the
> earthdistance function, but it doesn't seem to be recognised, even
> after a restart of the server.

> Is there a final step I need to take after using apt-get to install?

Yeah, you have to run the SQL script included in the module to define
its functions within a particular database.  Look for earthdistance.sql
among the files installed by the .deb (it's likely under /usr/share).

            regards, tom lane

On 10/25/06, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> "Stuart Grimshaw" <stuart.grimshaw@gmail.com> writes:
> > I've installed the postgresql-contrib8.1 deb package to get at the
> > earthdistance function, but it doesn't seem to be recognised, even
> > after a restart of the server.
>
> > Is there a final step I need to take after using apt-get to install?
>
> Yeah, you have to run the SQL script included in the module to define
> its functions within a particular database.  Look for earthdistance.sql
> among the files installed by the .deb (it's likely under /usr/share).

Thanks Tom, the .sql is stored in /usr/share/postgres/8.1/contrib

All sorted now.

--
-S

Sports Photography in South Yorkshire & Derbyshire
http://www.stuartgrimshaw.co.uk