I'm just wondering. Did you use a windows editor to alter the pg_hba.conf
file. If so you will need to run something like d2u from cygutils to change
to unix style end of lines.
- Stuart
> -----Original Message-----
> From: Dave Page [mailto:dpage@vale-housing.co.uk]
> Sent: 27 January 2002 21:34
> To: 'leo@junquera.com'; 'pgadmin-support@postgresql.org'
> Subject: Re: [pgadmin-support] help connecting to database
> using pgadmin
>
>
>
>
> > -----Original Message-----
> > From: Leonardo Junquera [mailto:leo@junquera.com]
> > Sent: 26 January 2002 03:50
> > To: pgadmin-support@postgresql.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@postgresql.org)
>