[PyGreSQL] Example of using "sslmode"

[Christoph Zwerschke]

D'Arcy J.M. Cain schrieb:
> Johannes Bauer wrote:
>> pg.InternalError: FATAL:  no pg_hba.conf entry for host 
>> "131.188.37.153", user "sijsbaue", database "prismpp_sijsbaue", SSL off
>>
>> Meaning it completely ignores the "sslmode" argument. How is this done?
> 
> This seems to be a PostgreSQL issue rather than a PyGreSQL issue but
> check your pg_hba file.  The message is telling you that you cannot
> connect from your current machine to the database server.

Actually it says that he cannot connect with SSL off. With SSL on it 
would work. That was his problem, so he tried with sslmode=require, but 
that didn't work because sslmode is not an option you can pass to 
connect() (only using the workaround I mentioned).

-- Christoph