Thread: pg_hba.conf is right ther, but connot connect
Hallo pgsql-cygwin, I have tried what is stated in the FAQ, create an entry in pg_hba.conf and checking the status of postmaster with pg_ctl tells me: /usr/bin/postmaster '-D' '/usr/share/postgresql/data' '-i' pg_hba.conf: # TYPE DATABASE USER IP-ADDRESS IP-MASK METHOD local all all trust host all all 127.0.0.1 255.255.255.255 trust host all all 192.168.5.3 255.255.255.0 trust When I try to connect from remote: $ psql -h 192.168.5.5 -d dbmail -U dbmail psql: FATAL: No pg_hba.conf entry for host 192.168.5.3, user dbmail, database dbmail What else may I check or try? Gerrit -- =^..^=
Gerrit, On Fri, Oct 17, 2003 at 01:56:35PM +0200, Gerrit P. Haase wrote: > What else may I check or try? Is the pg_hba.conf in text mode? Jason -- PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers Fingerprint: 7A73 1405 7F2B E669 C19D 8784 1AFD E4CC ECF4 8EF6
Gerrit P. Haase wrote: >Hallo pgsql-cygwin, > >I have tried what is stated in the FAQ, create an entry in pg_hba.conf >and checking the status of postmaster with pg_ctl tells me: >/usr/bin/postmaster '-D' '/usr/share/postgresql/data' '-i' > >pg_hba.conf: ># TYPE DATABASE USER IP-ADDRESS IP-MASK METHOD > >local all all trust >host all all 127.0.0.1 255.255.255.255 trust >host all all 192.168.5.3 255.255.255.0 trust > >When I try to connect from remote: >$ psql -h 192.168.5.5 -d dbmail -U dbmail >psql: FATAL: No pg_hba.conf entry for host 192.168.5.3, user dbmail, database dbmail > > >What else may I check or try? > > >Gerrit > > try to change tge IP-MASK to 255.255.255.255 But think twice before giving a trust relationship to that kind of entry ... Regards, Fred
Hello, >>pg_hba.conf: >># TYPE DATABASE USER IP-ADDRESS IP-MASK METHOD >> >>local all all trust >>host all all 127.0.0.1 255.255.255.255 trust >>host all all 192.168.5.3 255.255.255.0 trust >>When I try to connect from remote: >>$ psql -h 192.168.5.5 -d dbmail -U dbmail >>psql: FATAL: No pg_hba.conf entry for host 192.168.5.3, user dbmail, database dbmail >>What else may I check or try? > try to change tge IP-MASK to 255.255.255.255 > But think twice before giving a trust relationship to that kind of entry ... I'm behind a firawall, no problem with this. It works now with this IP_MASK after I shutdown the database completely, maybe pg_ctl reload doesn't work correct? Thanks for the help, Gerrit -- =^..^=
Hello Jason, sorry for sending you the answer with private mail, just delete it;) > Gerrit, > On Fri, Oct 17, 2003 at 01:56:35PM +0200, Gerrit P. Haase wrote: >> What else may I check or try? > Is the pg_hba.conf in text mode? No, it works now after shutting down the server completely, seems that pg_ctl reload doesn't work 100%? Gerrit -- =^..^=
Gerrit, On Fri, Oct 17, 2003 at 02:36:17PM +0200, Gerrit P. Haase wrote: > sorry for sending you the answer with private mail, just delete it;) No problem. > > On Fri, Oct 17, 2003 at 01:56:35PM +0200, Gerrit P. Haase wrote: > >> What else may I check or try? > > > Is the pg_hba.conf in text mode? > > No, it works now after shutting down the server completely, seems that > pg_ctl reload doesn't work 100%? Possibly. IIRC, I had some problems with pg_ctl restart too. I typically just restart the service to be sure. Sorry, I can't be anymore helpful. Jason -- PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers Fingerprint: 7A73 1405 7F2B E669 C19D 8784 1AFD E4CC ECF4 8EF6