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
>