Re: help connecting to database using pgadmin

Looks like you (Dave) and Josh were right. There is another pg_hba.conf under /var/lib/pgsql. Now I at least get a password error. I've got to track down this error and make sure I only have one directory for postgre.

Thanks again for your help.

---------- Original Message ----------------------------------
From: Dave Page <dpage(at)vale-housing(dot)co(dot)uk>
Date: Sun, 27 Jan 2002 21:33:52 -0000

>
>
>> -----Original Message-----
>> From: Leonardo Junquera [mailto:leo(at)junquera(dot)com]
>> Sent: 26 January 2002 03:50
>> To: pgadmin-support(at)postgresql(dot)org
>> Subject: [pgadmin-support] help connecting to database using pgadmin
>>
>>
>> i've got pgadmin II v 1.2 and postgre 7.1.1 and I'm having
>> trouble connecting to my database. Pgamin is running on xp
>> and postgre is running on a redhat linux box.
>>
>> The error i'm getting happens when i'm trying to connect:
>> Number: -214721843
>> Description: No pg_hba.conf entry for host 192.168.0.2, user
>> leoj, database sbm
>>
>> There is a line in my pg_hba.conf that reads:
>> host sbm 192.168.0.2 255.255.255.255 password
>> leoj
>>
>> I've tried it with with a number of combination including:
>> host all 192.168.0.2 255.255.255.0 trust
>> host sbm 192.168.0.2 255.255.255.255 ident leoj
>>
>> I've started postmaster with -i and I have tcpip_socket =
>> true in postgresql.conf.
>>
>> When i run "netstat -ta" i get:
>> tcp 0 0 *:postgres *:*
>> LISTEN
>>
>> When i run "ps -aux|grep postgre" i get:
>> postgres 22482 0.0 0.0 5052 0 ? SW 22:48 0:00
>> [postmaster]
>>
>
>Hmm, everything looks OK as you've described it. I assume 192.168.0.2 is the
>correct address for your XP box? You are obviously connecting to the server
>as you are getting that error message.
>
>I know it sounds odd, but are you sure you're editting the correct
>pg_hba.conf file? If you are running a hand compiled PostgreSQL on Redhat,
>it is possible that there is more than one PGDATA directory - the default
>from the Redhat RPM installation, and the one you're trying to use... Does
>that make any sense? :-)
>
>Regards, Dave.
>
>---------------------------(end of broadcast)---------------------------
>TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>