In the created db, the chat messages are stored in the ‘jm’ table for which the retention period seems to be 15 days. I would like to know if this can be increased and how.
Postgres itself does not have any way to define a retention period for data as you describe. Once the data goes in, the user or application must issue a statement to delete the data, This would be done by the application vendor ( Cisco). Most likely it’s a configuration option on the admin section of the application. I recommend you contact Cisco support for details.