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

[Paul Ramsey]

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.

P.