Feature Request: Possiblilty to pass PGSSLMODE to mapnik renderer

[cueball23]

To check the ssl certificate of the postgres server I need to set the PGSSLMODE environment variable for the renderer process.

I added the environment in the execute_renderer function in https://github.com/geofabrik/Tirex/blob/master/bin/tirex-backend-manager.

442 $ENV{'TIREX_BACKEND_SOCKET_FILENO'} = $socket_fileno;
443 $ENV{'PGSSLMODE'} = 'verify-full';
444 $ENV{'TIREX_BACKEND_DEBUG'} = 1 if ($Tirex::DEBUG || $renderer->get_debug());

It works for me, but I guess is shouldn't be hardcoded.
Maybe someone will find this useful.

[cueball23]

For this to work, you need the CA bundle in ~/.postgresql/root.crt, and a signed certificate on the postgres server.

[stephankn]

Does someone clear the environment? Otherwise you could simply set it before starting the backend manager and have it inherited.