From: | Dev Kumkar <devdas(dot)kumkar(at)gmail(dot)com> |
---|---|
To: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Facing authentication error on postgres 9.2 -> dblink functions |
Date: | 2013-02-06 17:59:08 |
Message-ID: | CALSLE1PqzB=_dXpsp4D4LNqv1CVYY27YZ_y+hVC2MfJmD6Qhxw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-hackers pgsql-sql |
Apologies for posting on multiple lists, surely will take care of this next
time.
Yup adding user=username resolved this. Thanks to 'Laurenz Albe' and you
too.
Regards - Dev
On Wed, Feb 6, 2013 at 7:12 PM, Andrew Dunstan <andrew(at)dunslane(dot)net> wrote:
>
> 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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Dev Kumkar | 2013-02-06 19:19:21 | Re: Facing authentication error on postgres 9.2 -> dblink functions |
Previous Message | Dev Kumkar | 2013-02-06 17:55:00 | Re: Facing authentication error on postgres 9.2 -> dblink functions |
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Dunstan | 2013-02-06 18:00:16 | Re: Alias hstore's ? to ~ so that it works with JDBC |
Previous Message | Joshua D. Drake | 2013-02-06 17:56:11 | Re: [COMMITTERS] pgsql: Fast promote mode skips checkpoint at end of recovery. |
From | Date | Subject | |
---|---|---|---|
Next Message | Francois Payette | 2013-02-06 18:15:42 | create an index on unnest |
Previous Message | Dev Kumkar | 2013-02-06 17:55:00 | Re: Facing authentication error on postgres 9.2 -> dblink functions |