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

Great.. thanks a lot Laurenz Albe!

Works perfect !!

Regards - Dev

On Wed, Feb 6, 2013 at 7:00 PM, Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>wrote:

> Dev Kumkar wrote:
> > 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?
>
> You should specify a user=username option in the connection string,
> otherwise that defaults to your operating system user name.
>
> Yours,
> Laurenz Albe
>