Re: 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" <tgl@sss.pgh.pa.us>
To: "Duncan McDonald" <duncan@gpats.com.au>
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
>