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@xxxxxxxxxxxxx>
To: "Duncan McDonald" <duncan@xxxxxxxxxxxx>
Cc: <pgsql-admin@xxxxxxxxxxxxxx>
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
