Facing authentication error on postgres 9.2 -> dblink functions

From: Dev Kumkar <devdas(dot)kumkar(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org
Subject: Facing authentication error on postgres 9.2 -> dblink functions
Date: 2013-02-06 13:09:16
Message-ID: CALSLE1Mc3d6yJFg0un4iRLRVp3dntdkLk5d+kkz7F8aOrZ-9oA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-hackers pgsql-sql

Hello Everyone,

I am using postgres 9.2 and when executing function dblink facing a fatal
error while trying 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?

Thanks..

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Albe Laurenz 2013-02-06 13:30:58 Re: [ADMIN] Facing authentication error on postgres 9.2 -> dblink functions
Previous Message Geoff Winkless 2013-02-06 12:12:52 Re: diskspace

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2013-02-06 13:27:37 Re: sql_drop Event Trigger
Previous Message Pavel Stehule 2013-02-06 12:58:58 Re: function for setting/getting same timestamp during whole transaction

Browse pgsql-sql by date

  From Date Subject
Next Message Albe Laurenz 2013-02-06 13:30:58 Re: [ADMIN] Facing authentication error on postgres 9.2 -> dblink functions
Previous Message Dev Kumkar 2013-02-06 11:01:00 Re: Querying multiple database