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 <[email protected]> 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 <[email protected]> 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, <[email protected]>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 >>> [email protected] >>> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users >>> >>> >> >> _______________________________________________ >> postgis-users mailing list >> [email protected] >> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users >> >> > > > -- > http://www.keittlab.org/ > > _______________________________________________ > postgis-users mailing list > [email protected] > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users > >
_______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
