[postgis-users] PostGIS Best Practices Question

[Tim Keitt]

I've used this sequence:

create database
install postgis
create schema
set default search to schema
load data

Then you can dump just the data by dumping only the schema and move it to
another database without dumping postgis bits.

THK


On Wed, Jul 17, 2013 at 8: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
>
>


-- 
http://www.keittlab.org/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20130717/28346deb/attachment.html>