PMM-10974 Fallback to PGSS in case of not available PGSM.

[JiriCtvrtka]

New PR for https://github.com/percona/pmm/pull/2823 with new ticket number.

PMM-10974

[JiriCtvrtka]

New PR opened under new number, but same like previous one: https://github.com/percona/pmm/pull/2823

Please reapprove it.

[codecov[bot]]

Codecov Report

Attention: Patch coverage is 21.05263% with 15 lines in your changes are missing coverage. Please review.

Project coverage is 42.23%. Comparing base (d2227cd) to head (8d124c2). Report is 1 commits behind head on main.

Files	Patch %	Lines
managed/services/management/postgresql.go	0.00%	10 Missing :warning:
agent/serviceinfobroker/service_info_broker.go	57.14%	2 Missing and 1 partial :warning:
admin/commands/management/add_postgresql.go	0.00%	1 Missing :warning:
managed/services/agents/service_info_broker.go	0.00%	1 Missing :warning:

Additional details and impacted files

@@            Coverage Diff             @@
##             main    #2827      +/-   ##
==========================================
- Coverage   42.23%   42.23%   -0.01%     
==========================================
  Files         396      396              
  Lines       50104    50120      +16     
==========================================
+ Hits        21162    21168       +6     
- Misses      26940    26950      +10     
  Partials     2002     2002              

Flag	Coverage Δ
admin	11.60% <0.00%> (-0.01%)	:arrow_down:
agent	53.20% <57.14%> (+<0.01%)	:arrow_up:
managed	42.78% <0.00%> (-0.01%)	:arrow_down:
vmproxy	68.57% <ø> (ø)

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.