[postgis-users] if i use postgis, is it true that i'll then have to worry about supporting only 1 database??

[John Smith]

thanks paul, chris and dane. we want to do web mapping but someone
important has come along, so i am just looking for some bullet points
from a system/support point. i'll just tell my worried system staff
it's easy to support- if it crashes/corrupts, they'd just have to
worry about backing and restoring 1 db.

http://pgfoundry.org/projects/dbi-link/
http://www.postgresql.org/docs/current/static/dblink.html
http://pgfoundry.org/projects/oralink/

jzs

On 2/6/08, Dane Springmeyer <blake at hailmail.net> wrote:
> John,
>
> If you have a lot of attribute data that all depends upon the same
> spatial columns it should not be a problem to establish all the
> relationships that would be needed to link many tables to one spatial
> geometry within one database.
>
> I'm not familiar with dblink: can you explain what is wrong with have
> "all your data" stored in one database?
>
> Once you get handy with postgres/postgis you'll find that syncing
> data in one database with another  (both which will reside in the
> postgres data folder) is really quick and easy. It you just want to
> pull data out to backup or convert to another RDMS like MySql that's
> pretty easy as well depending on how complex your schema is.
>
> Folks on this list have a ton of experience with using big datasets
> with complex tables. Send more specific concerns that I or others
> will try to answer.
>
> I'd also urge you to dive into using postgres/postgis right away with
> some sample datasets. It's often easier to visualize your questions
> once you've done so.
>
> Cheers,
>
> Dane
>
>
>
>
> On Feb 6, 2008, at 1:15 PM, John Smith wrote:
>
> > let me try this again:
> > if i use postgis, is it true that i'll then have to worry about
> > supporting only 1 database?? because all my data will then have to be
> > stored in only 1 database since dblink isn't recommended.
> > cheers, jzs
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users at postgis.refractions.net
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users