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.
