creating a specialized version of turnkey postgresql (Re: adding postgis support to turnkey postgresql)

From: Liraz Siri <liraz(at)turnkeylinux(dot)org>
To: Brent Wood <b(dot)wood(at)niwa(dot)co(dot)nz>
Cc: turnkey-discuss(at)lists(dot)turnkeylinux(dot)org, pgsql-general(at)postgresql(dot)org
Subject: creating a specialized version of turnkey postgresql (Re: adding postgis support to turnkey postgresql)
Date: 2008-12-09 22:51:59
Message-ID: 493EF68F.8030707@turnkeylinux.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I think it could be done but this is kind of a specialized
application that it is unlikely we will get in the near future, until we
get the much more common applications out of our queue.

Meanwhile you have several options: install the TurnKey PostgreSQL
appliance into a virtual machine such as VMware, Virtual PC or
VirtualBox, and then do the additional integration yourself. You could
then burn the virtual appliance onto DVD and take it with you to work.

If it's worth it to you, you could also hire one of our developers to
customize TurnKey PostgreSQL and create a specialized appliance just for
you.

Cheers,
Liraz

Brent Wood wrote:
> Sounds great, appreciated.
>
> I've just been running a DB workshop in Oman using Postgis & also QGIS & some other FOSS tools for them to set up & manage some spatial databases. All went very well, with some enthusiasm for the freedom of FOSS solutions compared to Oracle, ESRI, etc.
>
> Which leads to my next question :-)
>
> One of the great advantages of Postgis in the situations I work in (mostly maritime/fisheries/ecological/oceanographic), is that by adding apache & UMN mapserver you also have a complete & powerful web mapserver compliant with OGC WMS & WFS Web Services to disseminate maps drawn from Postgis data.
>
> I appreciate how easy it is to add these applications via apt-get, but as I found out in Oman, there are still places that do not have good enough internet access to allow this, & I understood the whole point of the TurnKey project was to avoid such external requirements.
>
> Do you think it feasible & reasonable that a TurnKey mapserver release could be implemented, basically by adding mapserver, apache, php & php mapscript to the Postgis CD or Postgis/mapserver to the LAPP CD? They are not large packages, and I think would fill a useful niche in line with the turnkey application goals of the TurnKey project.
>
>
> Cheers,
>
> Brent Wood
>
>
>
> Brent Wood
> DBA/GIS consultant
> NIWA, Wellington
> New Zealand
>>>> Liraz Siri <liraz(at)turnkeylinux(dot)org> 12/09/08 9:23 PM >>>
> Hi Brent,
>
> The current release of TurnKey PostgreSQL doesn't include postgis but it
> should be easy enough to add post-installation:
>
> apt-get install postgis postgresql-8.3-postgis
>
> Since the packages are quite small, we'll add them by default when we
> release the next version of the appliance.
>
> I've created a Launchpad blueprint for this feature:
>
> https://blueprints.launchpad.net/turnkeylinux/+spec/add-postgis-to-turnkey-postgresql
>
> If you subscribe you'll get updates.
>
> Cheers,
> Liraz
>
> Brent Wood wrote:
>> Hi,
>>
>> I was wondering if this includes, or could include, Postgis either by default or as an option?
>>
>> Postgis is easily the best FOSS OGC compliant spatial database implementation available & is inherently compatible with many FOSS GIS related applications.
>>
>>
>> Thanks,
>>
>> Brent Wood
>>
>> Brent Wood
>> DBA/GIS consultant
>> NIWA, Wellington
>> New Zealand
>> NIWA is the trading name of the National Institute of Water & Atmospheric Research Ltd.
>
> NIWA is the trading name of the National Institute of Water & Atmospheric Research Ltd.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Erik Jones 2008-12-09 23:12:06 Re: Possible bug with ALTER LANGUAGE ... OWNER TO ...
Previous Message Tom Lane 2008-12-09 22:35:10 Re: unstable SELECT performance under load