Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id D77929FB207 for ; Thu, 19 Oct 2006 11:22:07 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 13346-06-2 for ; Thu, 19 Oct 2006 14:20:26 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 9D5399FB30C for ; Thu, 19 Oct 2006 11:19:39 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from presinet.com (mail.presinet.com [209.53.156.1]) by svr4.postgresql.org (Postfix) with ESMTP id B1DFD5AF038 for ; Thu, 19 Oct 2006 14:19:37 +0000 (GMT) Received: from [10.10.1.151] ([10.10.1.151]) by presinet.com with Microsoft SMTPSVC(6.0.3790.1830); Thu, 19 Oct 2006 07:16:55 -0700 Message-ID: <45378976.5090208@presinet.com> Date: Thu, 19 Oct 2006 07:19:34 -0700 From: Bricklen Anderson User-Agent: Thunderbird 1.5.0.7 (X11/20060922) MIME-Version: 1.0 To: Duncan McDonald Cc: pgsql-admin@postgresql.org Subject: Re: Missing Earth Distance Functions Under Debian References: <01e701c6f30e$63f63790$2102a8c0@Firefly> In-Reply-To: <01e701c6f30e$63f63790$2102a8c0@Firefly> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 19 Oct 2006 14:16:55.0359 (UTC) FILETIME=[3B0FACF0:01C6F389] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200610/119 X-Sequence-Number: 23422 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 I apologise in advance if > this is an obvious question. > > Regards, > > -Duncan I think that it is in the postgresql-contrib-8.1 deb package available via aptitude (or whichever package manager you are using).