Re: Postgre connect on Postgre

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 to Slony. SkyTools
should provide less management headaches.

http://kaiv.wordpress.com/2007/09/02/postgresql-cluster-partitioning-with-plproxy-part-ii/

regards
Asko

On Wed, Aug 27, 2008 at 8:09 AM, Tino Wildenhain <tino(at)wildenhain(dot)de> wrote:

> 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 even more solutions (like slony for example).
>
> Regards
> Tino
>
> PS: the database likes to be called Postgresql or Postgres :-)
>
> On Tue, Aug 26, 2008 at 11:19 PM, Christophe <xof(at)thebuild(dot)com <mailto:
>> xof(at)thebuild(dot)com>> 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?
>>
>>
>> There is a module in contrib just for such a purpose:
>>
>> http://www.postgresql.org/docs/8.3/interactive/dblink.html
>>
>> -- Sent via pgsql-general mailing list (
>> pgsql-general(at)postgresql(dot)org
>> <mailto:pgsql-general(at)postgresql(dot)org>)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-general
>>
>>
>>
>