From: Andrew Dunstan <andrew@dunslane.net>
To: Dev Kumkar <devdas.kumkar@gmail.com>
Cc: pgsql-sql@postgresql.org
Cc: pgsql-admin@postgresql.org
Cc: pgsql-hackers@postgresql.org
Subject: Re: [HACKERS] Facing authentication error on postgres 9.2 -> dblink functions
Date: Wed, 06 Feb 2013 08:42:50 -0500
Message-ID: <51125DDA.4060702@dunslane.net> (raw)
In-Reply-To: <CALSLE1Mc3d6yJFg0un4iRLRVp3dntdkLk5d+kkz7F8aOrZ-9oA@mail.gmail.com>
References: <CALSLE1Mc3d6yJFg0un4iRLRVp3dntdkLk5d+kkz7F8aOrZ-9oA@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-sql>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: andrew@dunslane.net, devdas.kumkar@gmail.com, pgsql-admin@postgresql.org, pgsql-hackers@postgresql.org
Subject: Re: [HACKERS] Facing authentication error on postgres 9.2 -> dblink functions
In-Reply-To: <51125DDA.4060702@dunslane.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox