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

Paul Ramsey pramsey at opengeo.org
Thu Mar 22 09:16:59 PDT 2012

On Thu, Mar 22, 2012 at 4:53 AM, Tim Pigden <tim.pigden at optrak.com> 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.


More information about the postgis-users mailing list