Re: [ADMIN] Missing Earth Distance Functions Under Debian

2006-10-19 Thread Duncan McDonald
Hi Peter, That worked like a charm. Thanks for the help! Regards, -Duncan - Original Message - From: "Peter Eisentraut" <[EMAIL PROTECTED]> To: Cc: "Duncan McDonald" <[EMAIL PROTECTED]> Sent: Friday, October 20, 2006 1:09 AM Subject: Re

Re: [ADMIN] Missing Earth Distance Functions Under Debian

2006-10-19 Thread Peter Eisentraut
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.sql&searc

Re: [ADMIN] Missing Earth Distance Functions Under Debian

2006-10-19 Thread Bricklen Anderson
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

Re: [ADMIN] Missing Earth Distance Functions Under Debian

2006-10-18 Thread Duncan McDonald
in advance if this is an obvious question. Regards, -Duncan - Original Message - From: "Tom Lane" <[EMAIL PROTECTED]> To: "Duncan McDonald" <[EMAIL PROTECTED]> Cc: Sent: Tuesday, October 17, 2006 11:37 PM Subject: Re: [ADMIN] Missing Earth Dist

Re: [ADMIN] Missing Earth Distance Functions Under Debian

2006-10-17 Thread Tom Lane
"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 thin

[ADMIN] Missing Earth Distance Functions Under Debian

2006-10-16 Thread Duncan McDonald
Hi All. I was wondering whether someone could help me explain a weird PostgreSQL error I've encountered. I have two machines running Debian Sarge stable, the first has been operating as a database server for some time and the other I have just set up identically to run as a backup database. Bot