Re: [GENERAL] Postgre connect on Postgre

2008-09-01 Thread Asko Oja
If you are using functions take a look at plProxy. We created it after finding out that dblink wasn't good enough for us in oltp environments. There are also some security issues related to dblink that should be given serious consideration. As for replication SkyTools and Londiste are alternatives

Re: [GENERAL] Postgre connect on Postgre

2008-08-26 Thread Tino Wildenhain
Hi, Anderson dos Santos Donda wrote: Thanks man!! I'll study this module!! You should also be aware that sometimes instead of connecting two separate databases via dblink or similar, two schemas in one database can be used instead. It really depends on what you are really doing if there are

Re: [GENERAL] Postgre connect on Postgre

2008-08-26 Thread Anderson dos Santos Donda
Thanks man!! I'll study this module!! On Tue, Aug 26, 2008 at 11:19 PM, Christophe <[EMAIL PROTECTED]> wrote: > > On Aug 26, 2008, at 7:10 PM, Anderson dos Santos Donda wrote: > >> How I can connect a postgre database on another postgre database, and >> manipulate the datas on both database? >>

Re: [GENERAL] Postgre connect on Postgre

2008-08-26 Thread Christophe
On Aug 26, 2008, at 7:10 PM, Anderson dos Santos Donda wrote: How I can connect a postgre database on another postgre database, and manipulate the datas on both database? There is a module in contrib just for such a purpose: http://www.postgresql.org/docs/8.3/interactive/dblink.html

[GENERAL] Postgre connect on Postgre

2008-08-26 Thread Anderson dos Santos Donda
Hi All How I can connect a postgre database on another postgre database, and manipulate the datas on both database? Thanks!!