Great.. thanks a lot Laurenz Albe!
Works perfect !!
Regards - Dev
On Wed, Feb 6, 2013 at 7:00 PM, Albe Laurenz <laurenz.a...@wien.gv.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
>
