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
