Thread: 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/>