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

From Dev Kumkar
Subject Re: Facing authentication error on postgres 9.2 -> dblink functions
Date
Msg-id CALSLE1PqzB=_dXpsp4D4LNqv1CVYY27YZ_y+hVC2MfJmD6Qhxw@mail.gmail.com
Whole thread Raw
In response to Re: Facing authentication error on postgres 9.2 -> dblink functions  (Andrew Dunstan <andrew@dunslane.net>)
List pgsql-hackers
Apologies for posting on multiple lists, surely will take care of this next time.<br /><br />Yup adding user=username
resolvedthis. Thanks to 'Laurenz Albe' and you too.<br /><br />Regards - Dev<br /><br /><div class="gmail_quote"> On
Wed,Feb 6, 2013 at 7:12 PM, Andrew Dunstan <span dir="ltr"><<a href="mailto:andrew@dunslane.net"
target="_blank">andrew@dunslane.net</a>></span>wrote:<br /><blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px#ccc solid;padding-left:1ex"><div class="im"><br /> On 02/06/2013 08:09 AM, Dev Kumkar wrote:<br
/></div><blockquoteclass="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div
class="im">Hello Everyone,<br /><br /> I am using postgres 9.2 and when executing function dblink facing a fatal error
whiletrying to execute dblink_connect as follows:<br /><br /></div> /SELECT * FROM dblink_connect('host=127.0.0.1
port=5432dbname=postgres password=test')/<br /><br /> *ERROR*: could not establish connection DETAIL: FATAL: password
authenticationfailed for user "NETWORK SERVICE"<div class="im"><br /><br /> What this error is related to? Do I need to
modifypg_hba.conf file by any chance?<br /><br /> Thanks..<br /><br /></div></blockquote><br /><br /> Do NOT send
questionsto multiple lists. That is a waste of everybody's time. So do NOT follow up this email. This question belongs
onpgsql-general. If you have further questions pleease ask there.<br /><br /> The short answer is that you need to
providethe user name in your connect string.<br /><br /> cheers<span class="HOEnZb"><font color="#888888"><br /><br />
andrew<br/></font></span></blockquote></div><br /><br /> 

pgsql-hackers by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: [COMMITTERS] pgsql: Fast promote mode skips checkpoint at end of recovery.
Next
From: Andrew Dunstan
Date:
Subject: Re: Alias hstore's ? to ~ so that it works with JDBC