PostgreSQL client connection default settings

Andy Holt March 14, 2023

Does anyone know if Confluence Server / Data Center cares about or is affected by the various PostgreSQL client connection defaults as detailed here https://www.postgresql.org/docs/11/runtime-config-client.html ?

In particular, these:

datestyle
lc_messages
lc_monetary
lc_numeric
lc_time
timezone

I ask because I migrated a Confluence server from an old PG 9.2 database on Linux, to AWS RDS PG 9.6 (now at PG 11), and I spotted when preparing for the migration that these settings were different on the AWS RDS PG 9.6 when compared with the Linux PG 9.2.  I religiously copied these settings, via a new AWS RDS Parameter Group, but I now wonder if I needn't have bothered, and if the defaults used by AWS RDS PG are OK, because Confluence doesn't care anyway.

Any advice or experience gladly received!

Many thanks, Andy

0 answers

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events