[postgis-users] cross-database queries and choice of database configuration

shirabez shira at sfei.org
Fri Jun 29 14:10:13 PDT 2012


Following up on this thread from a few months ago, can you give a rationale
for this perspective? Why is it better to go with one database? Performance?
Simplicity? Both? Thanks,

Shira



Paul Ramsey-4 wrote
> 
> On Thu, Mar 22, 2012 at 4:53 AM, Tim Pigden <tim.pigden@> wrote:
>> Is this a practical approach for postgis type queries or do I have to put
>> it
>> all in one database to get good querying flexibility?
> 
> No, bad approach. Put it all in one database, with the application
> data in one schema and the geo data in another. Then for regular
> backups you can just backup the application schema separately.
> 
> P.
> _______________________________________________
> postgis-users mailing list
> postgis-users at .refractions
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> 


--
View this message in context: http://postgis.17.n6.nabble.com/cross-database-queries-and-choice-of-database-configuration-tp4644336p4998684.html
Sent from the PostGIS - User mailing list archive at Nabble.com.



More information about the postgis-users mailing list