Re: Querying multiple database

From: Dev Kumkar <devdas(dot)kumkar(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Querying multiple database
Date: 2013-02-06 11:01:00
Message-ID: CALSLE1O80QogOhzcWNqM8pnGaj36Wa+Te8=yKg7b0Vyz9_Ss7g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hello Again,

Using dblink and now am facing a fatal error while tryinf to execute
dblink_connect as follows:

SELECT *
FROM dblink_connect('host=127.0.0.1 port=5432 dbname=postgres
password=test')

ERROR: could not establish connection
DETAIL: FATAL: password authentication failed for user "NETWORK SERVICE"

What this error is related to? Do I need to modify pg_hba.conf file by any
chance?
Regards...

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Dev Kumkar 2013-02-06 13:09:16 Facing authentication error on postgres 9.2 -> dblink functions
Previous Message Dev Kumkar 2013-02-06 06:57:28 Re: Querying multiple database