> Hi > Postgres doesn't properly support cross-database queries but there seems to > something called dblink > > I'm looking at constructing a database which will have a point data > (customer locations, delivery records and other logistics info) but all the > other data is open-source feature data - boundaries, roads, etc. > > I had hoped to implement a structure witgh the feature data in one database > and put my application-specific data in another - not least because it > simplifies backups and so on. The feature data is very large and > slow-to-change whereas the logistics data is much smaller and more dynamic. > > 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? >
I would definitely use one database, eventually separating data into schemas. (but its only my opinion ;) ) For the backup, pg_dump allows you to backup only tables or schemas. I think it would be easier to manage than 2 databases. Nicolas _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
