Laravel PostgreSQL SSL encryption connection config

database.php

<?php
/**
* 1. You have to store your client SSL certificates on your Laravel server, in my case this is /var/certs/mydomain.com/...
* 2. You have to right select SSL mode for PostgreSQL (see https://www.postgresql.org/docs/current/libpq-ssl.html#LIBPQ-SSL-SSLMODE-STATEMENTS), verify-full means your server CA is signed for real domain name for the PostgreSQL server (recommended)
* 3. Go to Laravel config/database.php to the section 'pgsql' and extend it to the following:
*/
return [
  /*...*/
  'connections' => [
    /*'mysql' etc*/
    'pgsql' => [
      /*driver, host, database, username etc*/
      
      // sslmode
      // depends on your security level
      // @link https://www.postgresql.org/docs/current/libpq-ssl.html#LIBPQ-SSL-SSLMODE-STATEMENTS
      'sslmode' => 'verify-ca',
      
      /** DEPRECATED SINCE LARAVEL 10: 'option' KEY, */
      /** THANKS TO @andrewdevelop **/
      /*'options' => [
        'sslrootcert' => '/var/certs/mysite.com/postgresql-root.crt',
        'sslcert' => '/var/certs/mysite.com/postgresql-client.crt',
        'sslkey' => '/var/certs/mysite.com/postgresql-client.key',
      ]*/
      
      /** --- WORKING FOR NOW --- */
      'sslrootcert' => '/var/certs/mysite.com/postgresql-root.crt',
      'sslcert' => '/var/certs/mysite.com/postgresql-client.crt',
      'sslkey' => '/var/certs/mysite.com/postgresql-client.key',
    ]
  ]
];

I'm not sure exactly since which version of Laravel, but since version 10 the syntax has definitely changed. Instead of the options key, now the SSL parameters must be specified in the pgsql array

<?php
return [
    'connections' => [
        'pgsql' => [
	    // default settings here
            'sslmode' => 'verify-full',
            'sslrootcert' => base_path('/path/to/ca.crt'),
            'sslcert' => base_path('/path/to/client.crt'),
            'sslkey' => base_path('/path/to/client.key'),
        ],
//...

Thanks @andrewdevelop +1

I'm not sure exactly since which version of Laravel, but since version 10 the syntax has definitely changed. Instead of the options key, now the SSL parameters must be specified in the pgsql array

<?php
return [
    'connections' => [
        'pgsql' => [
	    // default settings here
            'sslmode' => 'verify-full',
            'sslrootcert' => base_path('/path/to/ca.crt'),
            'sslcert' => base_path('/path/to/client.crt'),
            'sslkey' => base_path('/path/to/client.key'),
        ],
//...

Thanks a lot!!!