SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-09-2008, 12:02 PM
| ||||
| ||||
 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 ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@postgresql.org so that your message can get through to the mailing list cleanly      |
|
04-09-2008, 12:02 PM
| |||
| |||
| Re: Enableing contrib modules on Debian "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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings |
|
04-09-2008, 12:03 PM
| ||||
| ||||
| Re: Enableing contrib modules on Debian 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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend |
Linear Mode
