Support jsonlog implementation

[JustinSongXh]

Description

Since PostgreSQL 15, JSON format log is supported. And PostgreSQL supports writing logs both in CSV and JSON format. Should cloudberry include this support as it might be useful in some cases such as event extraction of history log and alerting.

Use case/motivation

Writing log in JSON format might be useful when user want to extract data from a more completed format rather than a
simply comma split csv format. Directly parsing csv format log would be confusing if log field changed or one sql statement has to be written in multiple lines such as:

2025-04-29 15:35:46.778945 CST,"gpadmin","template1",p19156,th438892608,"127.0.0.1","38286",2025-04-29 15:35:46 CST,0,,cmd7,seg-1,,,,sx1,"LOG","00000","statement:
           SELECT dbid, content, role, preferred_role, mode, status,
           hostname, address, port, datadir
           FROM pg_catalog.gp_segment_configuration
           ORDER BY content, preferred_role DESC
           ",,,,,,,0,,"postgres.c",1715,

Since PostgreSQL starts to support both CSV and JSON log writing, it would be helpful to cherry-pick corresponding commits and make adaptation.

Related issues

No response

Are you willing to submit a PR?

• Yes I am willing to submit a PR!

[tuhaihe]

Already replied in #1120, but would like to copy my reply here again for your information:

There is a proposal related to upgrading the PG14 to PG16. Perhaps your work can be a part of this proposal: #1095.