Обсуждение: Querying multiple database
Hello everyone,
Please can you point me to the contrib/dblink package links.
What am actually looking for is query multiple database located on different machines. Is there any documentation for same which tells the metadata steps?
Existing archive link if exists please can you point me same.
Regards - Dev
Please can you point me to the contrib/dblink package links.
What am actually looking for is query multiple database located on different machines. Is there any documentation for same which tells the metadata steps?
Existing archive link if exists please can you point me same.
Regards - Dev
Am looking for pointers related to cross-database queries?
Thanks in advance!
--
:o) dev
Thanks in advance!
On Tue, Feb 5, 2013 at 10:42 PM, Dev Kumkar <devdas.kumkar@gmail.com> wrote:
Hello everyone,
Please can you point me to the contrib/dblink package links.
What am actually looking for is query multiple database located on different machines. Is there any documentation for same which tells the metadata steps?
Existing archive link if exists please can you point me same.
Regards - Dev
--
: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/>