Re: Missing Earth Distance Functions Under Debian

From: "Duncan McDonald" <duncan(at)gpats(dot)com(dot)au>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Missing Earth Distance Functions Under Debian
Date: 2006-10-18 23:37:35
Message-ID: 01e701c6f30e$63f63790$2102a8c0@Firefly
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(at)sss(dot)pgh(dot)pa(dot)us>
To: "Duncan McDonald" <duncan(at)gpats(dot)com(dot)au>
Cc: <pgsql-admin(at)postgresql(dot)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
>

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Benjamin Krajmalnik 2006-10-19 00:42:21 Rules/Triggers executio order
Previous Message Larry Rosenman 2006-10-18 20:59:22 Re: [PERFORM] autovacuum on a -mostly- r/o table