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

Hey went ahead and tried to query across machines and facing following
error:

SELECT * FROM dblink_connect('host=x.x.x.x port=5432 dbname=postgres
user=postgres password=test')

could not connect to server: Connection timed out (0x0000274C/10060)
Is the server running on host "x.y.z.com" (x.x.x.x) and accepting
TCP/IP connections on port 5432?

Tried modifying pg_hba as follows:
1st try
host all all 0.0.0.0/0 md5

2nd try
host all all .z.com md5

postgresql.conf looks good for connections and authentication:
listen_addresses = '*'

Please suggest?

Thanks...
On Wed, Feb 6, 2013 at 11:25 PM, Dev Kumkar <devdas(dot)kumkar(at)gmail(dot)com> wrote:

> 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
>>
>
>