I change the pg_hba.conf as below: hostssl all all 10.0.0.34/32 md5
But still the same problem. On Tue, May 4, 2010 at 5:03 PM, Thom Brown <[email protected]> wrote: > On 4 May 2010 11:50, AI Rumman <[email protected]> wrote: > >> I have created server.crt and server.key using the Postgresql >> documentation. >> >> Followings are the commands: >> ------------------------------------------- >> openssl req -new -text -out server.req >> >> openssl rsa -in privkey.pem -out server.key >> rm privkey.pem >> >> openssl req -x509 -in server.req -text -key server.key -out server.crt >> >> chmod og-rwx server.key >> ------------------------------------------- >> Mdified >> >> SSL=on at postgresql.conf and restarted the server. >> >> But when I am trying to connect I get the following error: >> >> FATAL: no pg_hba.conf entry for host "10.0.0.34", user "postgres", >> database "postgres", SSL off >> >> Please tell me why I get this error. >> > > > It appears you're not connecting securely and there's no access from your > IP specified in pg_hba.conf. You'll need to change that file and restart > the service. > > Thom >
