Postgres Pro
Downloads
Home   >   mailing lists

Facing authentication error on postgres 9.2 -> dblink functions - Mailing list pgsql-hackers

From Dev Kumkar
Subject Facing authentication error on postgres 9.2 -> dblink functions
Date
Msg-id CALSLE1Mc3d6yJFg0un4iRLRVp3dntdkLk5d+kkz7F8aOrZ-9oA@mail.gmail.com
Whole thread Raw
Responses Re: [ADMIN] Facing authentication error on postgres 9.2 -> dblink functions  (Albe Laurenz <laurenz.albe@wien.gv.at>)
Re: Facing authentication error on postgres 9.2 -> dblink functions  (Andrew Dunstan <andrew@dunslane.net>)
List pgsql-hackers
Tree view
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..

pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: function for setting/getting same timestamp during whole transaction
Next
From: Alvaro Herrera
Date:
Subject: Re: sql_drop Event Trigger