Обсуждение: Querying multiple database

<div class="gmail_quote">Hello everyone,<br /><br />Please can you point me to the contrib/dblink package links. <br
/><br/>What am actually looking for is query multiple database located on different machines. Is there any
documentationfor same which tells the metadata steps?<br /> Existing archive link if exists please can you point me
same.<br/><br />Regards - Dev<br /></div> 

Am looking for pointers related to cross-database queries?<br /><br />Thanks in advance!<br /><br /><div
class="gmail_quote">OnTue, Feb 5, 2013 at 10:42 PM, Dev Kumkar <span dir="ltr"><<a
href="mailto:devdas.kumkar@gmail.com"target="_blank">devdas.kumkar@gmail.com</a>></span> wrote:<br /><blockquote
class="gmail_quote"style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div class="gmail_quote">Hello
everyone,<br/><br />Please can you point me to the contrib/dblink package links. <br /><br />What am actually looking
foris query multiple database located on different machines. Is there any documentation for same which tells the
metadatasteps?<br /> Existing archive link if exists please can you point me same.<br /><br />Regards - Dev<br
/></div></blockquote></div><br/><br clear="all" /><br />-- <br />:o) dev  

Hello Again,<br /><br />Using dblink and now am facing a fatal error while tryinf to execute dblink_connect as
follows:<br/><br />SELECT *<br />FROM dblink_connect('host=127.0.0.1 port=5432 dbname=postgres password=test')<br /><br
/>ERROR: could not establish connection<br />DETAIL:  FATAL:  password authentication failed for user "NETWORK
SERVICE"<br/><br />What this error is related to? Do I need to modify pg_hba.conf file by any chance?<br />
Regards...<br/>