Menu ▾ ▴

#7 Enable support for SSL connections to PostgreSQL

open
nobody
None
5
2009-08-26
2009-08-26
Matthew X. Economou
No

By default, DBD::Pg doesn't use SSL connections to the database server. I'd like to have the option to encrypt database communications but don't necessarily need to configure that on the client side. The attached patch sets the SSL mode to "allow", which causes Sqlgrey to attempt an unencrypted database connection first, and then try an encrypted connection. I can control which is used on the database server by switching between "host" and "hostssl" in pg_hba.conf.

Discussion

  • Matthew X. Economou

    Matthew X. Economou - 2009-08-26

    Set "sslmode=allow" in PostgreSQL connection string

     
    sqlgrey-1.7.6-postgresql-allow-ssl.patch

  • Martin Matuska

    Martin Matuska - 2012-02-17

    Does the individually configurable db_dsn in 1.8.0 resolve this issue?
    If yes, I will close this request.