I'm currently setting up a fresh install of PostGIS 2.0.2 and PostgreSQL 9.1.6 on Ubuntu. I've recently come across some information indicating that using the public schema to store all data is not a good idea.
For this reason, I've set up a schema called data and made myself the owner. Here are my questions:
- Besides setting the owner, do I need to pay attention to anything on the Privileges tab when creating this new schema (through pgAdmin III)?
- Could I get the same benefits by storing my data in the public schema and dumping all data into a separate schema before doing a backup/restore (this would save a few keystrokes when using ogr2ogr)?
- Will I run into any trouble by not having the default PostGIS tables and views in my new data schema (they are in the public schema within the same database)?