Re: connections between servers

------=_Part_3309_18331064.1207250812936
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Thanks a lot, I'll give it a try.

regards
mk

2008/4/3, Shane Ambler <pgsql@[EMAIL PROTECTED]
>:
>
> Marcin Krawczyk wrote:
>
> > Hi all. I was wondering if it's possible for a trigger to perform
> > operations
> > on a database on different server? I saw somewhere that there's a
piece
> > of
> > software that allows conneciotns between different databases, but what
> > about
> > different servers? I also thought about using perl, would it be
possible
> > to
> > connect to different server from within perl trigger?
> > Thanks in advance.
> >
> > regards
> > mk
> >
> > Yes it is possible. A PL/Perl trigger is one option you have.
>
> dblink (in contrib) and dbi-link, dblink-tds, oralink and odbclink are
> other options at pgfoundry.org depending on your needs.
>
>
> There was a recent discussion in the general mailing list about this.
>
> http://archives.postgresql.org/pgsql-general/2008-03/msg01343.php
>
>
>
>
>
> --
>
> Shane Ambler
> pgSQL (at) Sheeky (dot) Biz
>
> Get Sheeky @[EMAIL PROTECTED]
 http://Sheeky.Biz
>

------=_Part_3309_18331064.1207250812936
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Thanks a lot, I&#39;ll give it a
try.<br><br>regards<br>mk<br><br><div><span class="gmail_quote">2008/4/3,
Shane Ambler &lt;<a
href="mailto:pgsql@[EMAIL PROTECTED]
">pgsql@[EMAIL PROTECTED]
>&gt;:</span><blockquote
class="gmail_quote" style="margin-top: 0; margin-right: 0; margin-bottom:
0; margin-left: 0; margin-left: 0.80ex; border-left-color: #cccccc;
border-left-width: 1px; border-left-style: solid; padding-left: 1ex">
<div><span class="e" id="q_119155ba3ab3d8ad_0">Marcin Krawczyk
wrote:<br><blockquote class="gmail_quote" style="border-left-color:
#cccccc; border-left-width: 1px; border-left-style: solid; padding-left:
1ex"> Hi all. I was wondering if it&#39;s possible for a trigger to
perform operations<br>
 on a database on different server? I saw somewhere that there&#39;s a
piece of<br> software that allows conneciotns between different databases,
but what about<br> different servers? I also thought about using perl,
would it be possible to<br>
 connect to different server from within perl trigger?<br> Thanks in
advance.<br><br> regards<br> mk<br><br></blockquote></span></div> Yes it
is possible. A PL/Perl trigger is one option you have.<br><br> dblink (in
contrib) and dbi-link, dblink-tds, oralink and odbclink are other options
at <a href="http://pgfoundry.org"
target="_blank" onclick="return
top.js.OpenExtLink(window,event,this)">pgfoundry.org</a> depending on your
needs.<br>
<br><br> There was a recent discussion in the general mailing list about
this.<br><br><a
href="http://archives.postgresql.org/pgsql-general/2008-03/msg01343.php"
target="_blank" onclick="return
top.js.OpenExtLink(window,event,this)">http://archives.postgresql.org/pgsql-general/2008-03/msg01343.php</a><br>
<span class="sg"><br><br><br><br><br> -- <br><br> Shane Ambler<br> pgSQL
(at) Sheeky (dot) Biz<br><br> Get Sheeky @[EMAIL PROTECTED]
 <a href="http://Sheeky.Biz"
target="_blank" onclick="return
top.js.OpenExtLink(window,event,this)">http://Sheeky.Biz</a><br>
</span></blockquote></div><br>

------=_Part_3309_18331064.1207250812936--