Message-ID: <51125DDA.4060702@dunslane.net>
Date: Wed, 06 Feb 2013 08:42:50 -0500
From: Andrew Dunstan <andrew@dunslane.net>
User-Agent: Mozilla/5.0 (X11; Linux x86_64;
	rv:15.0) Gecko/20120827 Thunderbird/15.0
MIME-Version: 1.0
To: Dev Kumkar <devdas.kumkar@gmail.com>
CC: pgsql-sql@postgresql.org, pgsql-admin@postgresql.org,
	pgsql-hackers@postgresql.org
Subject: Re: [HACKERS] Facing authentication error on postgres 9.2 -> dblink
	functions
References: 
 <CALSLE1Mc3d6yJFg0un4iRLRVp3dntdkLk5d+kkz7F8aOrZ-9oA@mail.gmail.com>
In-Reply-To: 
 <CALSLE1Mc3d6yJFg0un4iRLRVp3dntdkLk5d+kkz7F8aOrZ-9oA@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-sql-owner@postgresql.org


On 02/06/2013 08:09 AM, Dev Kumkar wrote:
> 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..
>


Do NOT send questions to multiple lists. That is a waste of everybody's 
time. So do NOT follow up this email. This question belongs on 
pgsql-general. If you have further questions pleease ask there.

The short answer is that you need to provide the user name in your 
connect string.

cheers

andrew


-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql