diff -u b/sites/default/default.settings.php b/sites/default/default.settings.php --- b/sites/default/default.settings.php +++ b/sites/default/default.settings.php @@ -193,8 +193,8 @@ * ); * @endcode * - * Advanced users can also specify database layer connection security using the - * 'pdo' attribute array as follows: + * Advanced users can also specify MySQL database layer connection security using the + * 'pdo' attribute for array as follows: * @code * 'pdo' => [ * MYSQL_ATTR_SSL_KEY => '/path/to/ssl-cert.key', @@ -206,6 +206,30 @@ * ], * @endcode * + * Now if you have the following settings in PostgreSQL: + * @code + * $databases['default']['default'] = array( + * 'init_commands' => array( + * 'sslmode' => 'require', + * ), + * ); + * @endcode + * + * For PostgreSQL SSL connection use the following settings: + * @code + * 'pdo' => [ + * PGSQL_ATTR_SSL_KEY => '/path/to/ssl-cert.key', + * PGSQL_ATTR_SSL_CERT => '/path/to/ssl-cert.crt', + * PGSQL_ATTR_SSL_CA => '/path/to/ca-cert.crt', + * // Optional + * PGSQL_ATTR_SSL_CAPATH => '/ca/path', + * PGSQL_ATTR_SSL_CIPHER => 'ssl cipher', + * ], + * @endcode + * + * For SQLite database ssl connection settings are not required as it is + * only supported on localhost. + * * Any features supported by the PDO driver of the database can be put into * the 'pdo' attribute array, as defined in the php documentation. * @url http://php.net/manual/en/pdo.drivers.php