[fix][sec] Upgrade postgresql version to avoid CVE-2024-1597

[nikhilerigila09]

Fixes https://github.com/apache/pulsar/issues/22625

Motivation

Avoid CVE-2024-1597

Modifications

Upgrade postgresql version to 42.5.5

Verifying this change

• [X] Make sure that the change passes the CI checks.

Does this pull request potentially affect one of the following parts:

If the box was checked, please highlight the changes

• [X] Dependencies (add or upgrade a dependency)
• [ ] The public API
• [ ] The schema
• [ ] The default values of configurations
• [ ] The threading model
• [ ] The binary protocol
• [ ] The REST endpoints
• [ ] The admin CLI options
• [ ] The metrics
• [ ] Anything that affects deployment

Documentation

• [ ] doc
• [ ] doc-required
• [X] doc-not-needed
• [ ] doc-complete

[lhotari]

@nikhilerigila09 There's a merge conflict and this PR has been created without allowing edits from maintainers, so you'd have to do the merge conflict resolution.

[nikhil-ctds]

@lhotari I've rebased my branch, conflicts have been resolved now.

[codecov-commenter]

Codecov Report

All modified and coverable lines are covered by tests :white_check_mark:

Project coverage is 72.68%. Comparing base (bbc6224) to head (82c1102). Report is 240 commits behind head on master.

Additional details and impacted files

@@             Coverage Diff              @@
##             master   #22635      +/-   ##
============================================
- Coverage     73.57%   72.68%   -0.89%     
+ Complexity    32624    32329     -295     
============================================
  Files          1877     1887      +10     
  Lines        139502   141018    +1516     
  Branches      15299    15480     +181     
============================================
- Hits         102638   102505     -133     
- Misses        28908    30656    +1748     
+ Partials       7956     7857      -99     

Flag	Coverage Δ
inttests	27.46% <ø> (+2.88%)	:arrow_up:
systests	24.55% <ø> (+0.22%)	:arrow_up:
unittests	71.46% <ø> (-1.39%)	:arrow_down:

Flags with carried forward coverage won't be shown. Click here to find out more.

see 343 files with indirect coverage changes