Anybody using PostGIS?

CSN wrote:

I've been meaning to try out PostGIS and see what it
is capable of. Is anybody using it? Do you have
accompanying URLs?

Yes: www.anisite.com (see http://www.anisite.com/state.php?state=FL). I
am using it to serve dynamic layers for UMN Mapserver. Setup was fairly
easy, and it chugs along great even on a low-end Sempron with 384 MB
RAM. Provides a nice way to get interactive info into a mapping system.

Regards,

Rick

On Oct 17, 2005, at 12:47 , CSN wrote:

I've been meaning to try out PostGIS and see what it
is capable of. Is anybody using it? Do you have
accompanying URLs?

The best place to get information on PostGIS is from the PostGIS
site. You may want to join their mailing list as well.
http://postgis.refractions.net/

Michael Glaesemann
grzm myrealbox com

On Sun, 16 Oct 2005, CSN wrote:

I've been meaning to try out PostGIS and see what it
is capable of. Is anybody using it? Do you have
accompanying URLs?

www.postgis.org is the obvious one, which probably doesn't help much :-)

I'm using it extensively, underlying a few reasonably functional GIS
systems using JUMP & QGIS to view PostGIS tables as GIS map layers.

I've also used Postgis for some interesting spatial overlay analysis
with some antarctic data (well, I thought they were interesting),
entirely done with SQL.

I have a PC with NX server running (just a demo right now), which also has
Postgis & QGIS installed. If you contact me off list I can give you a
login & you can see for yourself (email: pcreso@pcreso.com).
The NX client is freely available from www.nomachine.com. If you don't
like NX, you can ssh in, but it is slower.

Cheers,

Brent Wood

Hi,

On Sun, 16 Oct 2005, CSN wrote:

I've been meaning to try out PostGIS and see what it
is capable of. Is anybody using it? Do you have
accompanying URLs?

There are mailing lists for PostGIS-related questions.

See http://www.PostGIS.org for the details.

Regards,
--
Devrim GUNDUZ
Kivi Bili�im Teknolojileri - http://www.kivi.com.tr
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org

From pgsql-general-owner@postgresql.org Mon Oct 17 09:21:41 2005

X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
by svr1.postgresql.org (Postfix) with ESMTP id 92841D80E2
for <pgsql-general-postgresql.org@localhost.postgresql.org>; Mon, 17 Oct 2005 09:13:06 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
with ESMTP id 58936-09
for <pgsql-general-postgresql.org@localhost.postgresql.org>;
Mon, 17 Oct 2005 12:13:02 +0000 (GMT)
Received: from zoraida.natserv.net (p65-147.acedsl.com [66.114.65.147])
by svr1.postgresql.org (Postfix) with ESMTP id A3E03D8077
for <pgsql-general@postgresql.org>; Mon, 17 Oct 2005 09:13:03 -0300 (ADT)
Received: from localhost (localhost.natserv.net [127.0.0.1])
by zoraida.natserv.net (Postfix) with ESMTP id 822F77E58;
Mon, 17 Oct 2005 08:13:07 -0400 (EDT)
Date: Mon, 17 Oct 2005 08:13:07 -0400 (EDT)
From: Francisco Reyes <lists@natserv.com>
X-X-Sender: fran@zoraida.natserv.net
To: Richard Huxton <dev@archonet.com>
Cc: pgsql General List <pgsql-general@postgresql.org>
Subject: Re: Safe to kill idle connections?
In-Reply-To: <43536231.9030505@archonet.com>
Message-ID: <20051017081105.H12366@zoraida.natserv.net>
References: <20051016204017.C3522@zoraida.natserv.net> <43536231.9030505@archonet.com>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.177 required=5 tests=[AWL=0.127,
FORGED_RCVD_HELO=0.05]
X-Spam-Level:
X-Archive-Number: 200510/959
X-Sequence-Number: 85188

On Mon, 17 Oct 2005, Richard Huxton wrote:

At a guess, PHPWiki is using persistent connections to PG, so you'll get one
connection per Apache backend.

Thanks for the info. That may well be the problem.

Alternatively, a small change in PHPWiki's code should clear it too (start
with a search for pg_pconnect and try pg_connect instead).

Will do.

It's perfectly safe to leave the idle connections there - they won't take up
much in the way of resources.

How about when one needs to reload to read new postgresql.conf files. Will
iddle connections prevent the server from reloading?

Also, in the future if other programs do the same, is it safe to kill
these and if so what is the best way? kill command?

Yes, we are using PostGIS with JUMP GIS.
http://www.jump-project.org/
http://openjump.org

CSN schrieb:

CSN,
We use PostGIS extensively on our DataDoors product
[http://www.datadoors.net].

- Onyx
---
Onyx Mueller
Software Engineer
i-cubed : information integration & imaging LLC
201 Linden Street : Third Floor
Fort Collins, CO 80524
970-482-4400 voice
970-482-4499 fax
www.i3.com