Обсуждение: Connecting to a remote server, pg_hba.conf error?
I am trying to connect to a postgres 8.1 installation on a ubuntu box from windows xp. I get this error: FATAL: missing or erroneous pg_hba.conf file HINT see server log for details. The server ip address is 192.168.1.10. The workstation ip address is 192.168.2.100. The server firewall allows connections on port 5432. I am past the 'is the server open on port 5432?' errors, now it's 'missing or erroneous pg_hba.conf'. I've added a line like this to that file: host all all 192.168.2.100 md5 (have tried trust also) As far as spacing of those entries goes, it's in keeping with the other entries. Also I edited the postgresql.conf file so that listen_address = '*' If I rem the line I added, I get a different error message (FATAL: no pg_hba.conf entry for host "192.168.1.100", user "postgres", database "template1", SSL off). Note that is not the ip address of the xp workstation (192.168.2.100) or the ubuntu server (192.168.1.10), that's the ip address of a router that stands between them. But I'm guessing that the workstation can 'see' the ubuntu postgresql installation, or altering the pg_hba.conf file wouldn't have any effect at all. I'd sure appreciate any help with this. I'm not sure how to check the log on the ubuntu server as the error suggests...yes, I'm new to this, might do better if I could could use one of the postgres gui tools, but that's exactly what I'm not able to do at the moment <g>. -- View this message in context: http://www.nabble.com/Connecting-to-a-remote-server%2C-pg_hba.conf-error--tf3297991.html#a9174496 Sent from the PostgreSQL - general mailing list archive at Nabble.com.
novnov <novnovice@gmail.com> writes: > I am trying to connect to a postgres 8.1 installation on a ubuntu box from > windows xp. I get this error: FATAL: missing or erroneous pg_hba.conf file > HINT see server log for details. > > The server ip address is 192.168.1.10. The workstation ip address is > 192.168.2.100. The server firewall allows connections on port 5432. I am > past the 'is the server open on port 5432?' errors, now it's 'missing or > erroneous pg_hba.conf'. I've added a line like this to that file: > > host all all 192.168.2.100 md5 (have tried trust also) I think you need a netmask on this IP: host all all 192.168.2.100/32 md5 -Doug
Wonderful, that solved it...THANK YOU! Douglas McNaught wrote: > > novnov <novnovice@gmail.com> writes: > >> I am trying to connect to a postgres 8.1 installation on a ubuntu box >> from >> windows xp. I get this error: FATAL: missing or erroneous pg_hba.conf >> file >> HINT see server log for details. >> >> The server ip address is 192.168.1.10. The workstation ip address is >> 192.168.2.100. The server firewall allows connections on port 5432. I am >> past the 'is the server open on port 5432?' errors, now it's 'missing or >> erroneous pg_hba.conf'. I've added a line like this to that file: >> >> host all all 192.168.2.100 md5 (have tried trust also) > > I think you need a netmask on this IP: > > host all all 192.168.2.100/32 md5 > > -Doug > > ---------------------------(end of broadcast)--------------------------- > TIP 3: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq > > -- View this message in context: http://www.nabble.com/Connecting-to-a-remote-server%2C-pg_hba.conf-error--tf3297991.html#a9175269 Sent from the PostgreSQL - general mailing list archive at Nabble.com.