Re: [HACKERS] Facing authentication error on postgres 9.2 -> dblink functions

2013-02-06 Thread Dev Kumkar 
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  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
>

Re: [HACKERS] Facing authentication error on postgres 9.2 -> dblink functions

2013-02-06 Thread Andrew Dunstan 


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-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

[HACKERS] Facing authentication error on postgres 9.2 -> dblink functions

2013-02-06 Thread Dev Kumkar 
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..