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
<andrew@dunslane.net> 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
