Thread: contrib/dblink suggestion
Hi, I am using postgresql 7.2.1. I badly require to interconnect between databases. contrib/dblink seems to be handy and ofcourse it well suits my requirement. But while browsing across, i heard that it is not advicable to use it. So i wish to know someone's experience in using dblink and how handy it is. Will contrib/dblink be available with future postgresql releases? Valuable suggestions are very welcome. TIA. regards, bhuvaneswaran
dblink is fine to use, and will continue to be shipped with PostgreSQL. Not sure where you heard about problems with it. --------------------------------------------------------------------------- Bhuvan A wrote: > Hi, > > I am using postgresql 7.2.1. > I badly require to interconnect between databases. contrib/dblink seems to > be handy and ofcourse it well suits my requirement. But while browsing > across, i heard that it is not advicable to use it. So i wish to know > someone's experience in using dblink and how handy it is. > > Will contrib/dblink be available with future postgresql releases? Valuable > suggestions are very welcome. > > TIA. > > regards, > bhuvaneswaran > > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) > -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania19026
Bhuvan A wrote: > I am using postgresql 7.2.1. > I badly require to interconnect between databases. contrib/dblink seems to > be handy and ofcourse it well suits my requirement. But while browsing > across, i heard that it is not advicable to use it. So i wish to know > someone's experience in using dblink and how handy it is. > > Will contrib/dblink be available with future postgresql releases? Valuable > suggestions are very welcome. > I've heard of at least two people who seem to be using dblink fairly heavily without problems. One recently reported something like 500 million records transferred without error. I use it myself, but not in what I'd call heavy use. If you are aware of any specific problems, please point me to them, and I'll fix them before the next release. Thanks, Joe
Dear Mr.Joe Conway, Thank you very much for your suggestion. Really nowhere i got to know about specific problem in dblink. But some discussions had went on this mailing list long back and here is that link http://archives.postgresql.org/pgsql-sql/2002-05/msg00007.php Anyway thank you once again. regards, bhuvaneswaran On Tue, 30 Jul 2002, Joe Conway wrote: > Bhuvan A wrote: > > I am using postgresql 7.2.1. > > I badly require to interconnect between databases. contrib/dblink seems to > > be handy and ofcourse it well suits my requirement. But while browsing > > across, i heard that it is not advicable to use it. So i wish to know > > someone's experience in using dblink and how handy it is. > > > > Will contrib/dblink be available with future postgresql releases? Valuable > > suggestions are very welcome. > > > > I've heard of at least two people who seem to be using dblink fairly > heavily without problems. One recently reported something like 500 > million records transferred without error. I use it myself, but not in > what I'd call heavy use. > > If you are aware of any specific problems, please point me to them, and > I'll fix them before the next release. > > Thanks, > > Joe >