Issue with PostgreSQL SSL connection

[narendrapatel]

Facing issue similar to #6482

We are facing similar issue with the exact error as in the linked issue. It works when i have postgresql on the same instance as kong with a self signed certificate, but does not work with a remote cloud managed PostgreSQL database with the cloud provided CA.

Error when start Kong with -vv:

Error:
/usr/local/share/lua/5.1/kong/cmd/start.lua:19: [postgres error] could not retrieve server_version: FATAL: connection requires a valid client certificate
stack traceback:
	[C]: in function 'error'
	/usr/local/share/lua/5.1/kong/cmd/start.lua:19: in function 'cmd_exec'
	/usr/local/share/lua/5.1/kong/cmd/init.lua:87: in function </usr/local/share/lua/5.1/kong/cmd/init.lua:87>
	[C]: in function 'xpcall'
	/usr/local/share/lua/5.1/kong/cmd/init.lua:87: in function </usr/local/share/lua/5.1/kong/cmd/init.lua:44>
	/usr/local/bin/kong:7: in function 'file_gen'
	init_worker_by_lua:49: in function <init_worker_by_lua:47>
	[C]: in function 'xpcall'
	init_worker_by_lua:56: in function <init_worker_by_lua:54>

In #2856, Kong worked with Amazon RDS. I've tried fiddling with lua_ssl_trusted_certificate and lua_ssl_verify_depth but could not get it working with remote cloud postgresql.
Our cloud setup is GCP. Has anyone tried to bring Kong up with PostgreSQL SSL mode in GCP?

Kong Version : 0.13.0
OS : Centos 7.9

Any leads would be really helpful.