[postgis-users] PostGIS Best Practices Question

[Bborie Park]

Rick,

First thing, upgrade your PostgreSQL servers to 9.2.4 due to the security
fixes. Then install PostGIS using the CREATE EXTENSION approach into a
separate schema on each database to be spatially-enabled.

-bborie


On Wed, Jul 17, 2013 at 6:22 AM, <Rick_Higginbotham at unigroupinc.com> wrote:

> Hello All,
>
> We are embarking down the open source software stack road and we are
> looking to get off on the right foot with PostGIS so I thought the best
> place to start would be to ask the list a question.  We are currently
> running Postgres 9.2.2 on RHEL 6.3.  We have already created 5 pairs
> (master/standby streaming) of Postgres database cluster to support the
> various business functions.  We currently do not have the PostGIS extension
> enabled on any of our existing databases.
>
> My best practices questions involve our existing suite of Postgres
> database clusters.  What are the best practice recommendations for enabling
> geo spatial features on existing Postgres databases?  Should we build new
> Postgres database cluster servers, enable PostGIS on the new database
> clusters and extract and load into the new environment for the existing
> databases that we what to geo spatial enable or geo spatial our existing
> database by creating the PostGIS extension on the existing database
> clusters?
>
> Are there cons to installing PostGIS and enabling the geospacial
> extensions on a system with 5 schema's where only 1 schema has a geospacial
> requirement??
>
> Thanks for everyone's input and please let me know if you need any more
> details.
>
> -Rick Higginbotham
>
> ########################################################################
> The information contained in this message, and any attachments thereto,
> is intended solely for the use of the addressee(s) and may contain
> confidential and/or privileged material.  Any review, retransmission,
> dissemination, copying, or other use of the transmitted information is
> prohibited.  If you received this in error, please contact the sender
> and delete the material from any computer.  UNIGROUPINC.COM
> ########################################################################
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20130717/90c5c334/attachment.html>