Thread: 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] Any suggestions would be appreciated.
> -----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.
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) >
Looks like you (Dave) and Josh were right. There is another pg_hba.conf under /var/lib/pgsql. Now I at least get a passworderror. 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@vale-housing.co.uk> Date: Sun, 27 Jan 2002 21:33:52 -0000 > > >> -----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) >