[postgis-users] Basic question #3 schemas

Kevin Neufeld kneufeld at refractions.net
Thu Feb 19 21:12:45 PST 2009


Ben Madin wrote:
> thank you very much for this - can I just clarify:
>
> When you install a new PostGIS, you install the 'current' postgis into 
> the public schema, but all your data & functions into other schemas;
>
Yes, that's my preference anyway.   Upgrading then is simply a task of 
creating a new PostgreSQL database cluster installed with a new PostGIS 
database and pg_dumping your schemas to the new database.

-- Kevin



More information about the postgis-users mailing list