[postgis-users] PostGIS Best Practices Question

[Bborie Park]

If you put PostGIS in its own schema, you just need to add that schema to
the search path.

SET search_path = schema1, schema2, postgis, public;

I find that using a separate schema for PostGIS maximizes the separation
between "system" code/data and "my" code/data.

-bborie


On Thu, Jul 18, 2013 at 8:56 AM, Tim Keitt <tkeitt at utexas.edu> wrote:

> Does postgis have to be in public, or just the search path? I've not tried
> putting it into its own schema separate from the data (eg postgis in
> postgis schema, data in data schema). I've often thought that would be
> cleaner. I just have not tested it.
>
> THK
>
>
> On Wed, Jul 17, 2013 at 3:16 PM, Bborie Park <dustymugs at gmail.com> wrote:
>
>> 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
>>>
>>>
>>
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at lists.osgeo.org
>> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>>
>>
>
>
> --
> http://www.keittlab.org/
>
> _______________________________________________
> 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/20130718/6bd2a092/attachment.html>