Re: [ADMIN] Missing Earth Distance Functions Under Debian
Duncan McDonald wrote: Hi Tom, Thanks for the reply. No I didn't run the earthdistance.sql script on the backup database, is this included with the standard PostgreSQL package? If not, would you mind letting me know how/where to obtain it? I'm relatively new to PostgreSQL administration so I apologise in advance if this is an obvious question. Regards, -Duncan I think that it is in the postgresql-contrib-8.1 deb package available via aptitude (or whichever package manager you are using). ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [ADMIN] Missing Earth Distance Functions Under Debian
Duncan McDonald wrote: No I didn't run the earthdistance.sql script on the backup database, is this included with the standard PostgreSQL package? If not, would you mind letting me know how/where to obtain it? http://packages.debian.org/cgi-bin/search_contents.pl?word=earthdistance.sqlsearchmode=searchfilescase=insensitiveversion=stablearch=i386 -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [ADMIN] Missing Earth Distance Functions Under Debian
Hi Peter, That worked like a charm. Thanks for the help! Regards, -Duncan - Original Message - From: Peter Eisentraut [EMAIL PROTECTED] To: pgsql-admin@postgresql.org Cc: Duncan McDonald [EMAIL PROTECTED] Sent: Friday, October 20, 2006 1:09 AM Subject: Re: [ADMIN] Missing Earth Distance Functions Under Debian Duncan McDonald wrote: No I didn't run the earthdistance.sql script on the backup database, is this included with the standard PostgreSQL package? If not, would you mind letting me know how/where to obtain it? http://packages.debian.org/cgi-bin/search_contents.pl?word=earthdistance.sqlsearchmode=searchfilescase=insensitiveversion=stablearch=i386 -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
Re: [ADMIN] Missing Earth Distance Functions Under Debian
Hi Tom, Thanks for the reply. No I didn't run the earthdistance.sql script on the backup database, is this included with the standard PostgreSQL package? If not, would you mind letting me know how/where to obtain it? I'm relatively new to PostgreSQL administration so I apologise in advance if this is an obvious question. Regards, -Duncan - Original Message - From: Tom Lane [EMAIL PROTECTED] To: Duncan McDonald [EMAIL PROTECTED] Cc: pgsql-admin@postgresql.org Sent: Tuesday, October 17, 2006 11:37 PM Subject: Re: [ADMIN] Missing Earth Distance Functions Under Debian ... I think you forgot to execute the earthdistance.sql script to define the functions within the current database. regards, tom lane ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
Re: [ADMIN] Missing Earth Distance Functions Under Debian
Duncan McDonald [EMAIL PROTECTED] writes: ERROR: function ll_to_earth(numeric, numeric) does not exist HINT: No function matches the given name and argument types. You may need to add explicit type casts. I've tried reinstalling the package in question but it had no effect. I think you forgot to execute the earthdistance.sql script to define the functions within the current database. regards, tom lane ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly