WIP Update CI with newer PHP and PSQL versions

[PhilinTv]

1. We need to include the PHP 8.3 in the standard CI process.
2. We need to ensure compatibility with the latest PSQL versions (atm the jobs are stopped).

[codecov-commenter]

Codecov Report

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

Project coverage is 87.70%. Comparing base (1ca6543) to head (7ed71c2).

:exclamation: Your organization needs to install the Codecov GitHub app to enable full functionality.

Additional details and impacted files

@@             Coverage Diff              @@
##             master    #1995      +/-   ##
============================================
- Coverage     89.28%   87.70%   -1.58%     
  Complexity     8058     8058              
============================================
  Files           232      232              
  Lines         24534    24534              
============================================
- Hits          21905    21518     -387     
- Misses         2629     3016     +387     

Flag	Coverage Δ
5-max	87.70% <ø> (-1.58%)	:arrow_down:
7.4	87.70% <ø> (-1.58%)	:arrow_down:
agnostic	67.44% <ø> (ø)
mysql	69.83% <ø> (ø)
pgsql	?
sqlite	67.81% <ø> (ø)

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

:umbrella: View full report in Codecov by Sentry.
:loudspeaker: Have feedback on the report? Share it here.

[smhg]

@PhilinTv if you rebase this, only the Pgsql change remains. If still useful, I think it's good to merge? Although maybe wait for the rebase push to run the testsuite?

[smhg]

@PhilinTv if you merge #2052 into this branch, I think this PR is ready to go. It was trying to run those Postgres tests on PHP 7.4 with Symfony 6.x but this combination is excluded. Symfony 5 is the only version that runs on 7.4.