Bump to latest PG minors in CI images

[hanefi]

This PR aims to capture the changes in our test suite to use the latest PG minor versions for 13 and 14.

Blocked on #6075 as we need to have matching libpq and PG minor versions in images here.

TODO:

• [x] Remove extra invalid socket messages that may be preceded with some blank lines
• [x] Normalize the messages that changed from connection not open to invalid socket after libpq upgrades to newer minor versions
• [ ] Extra warning messages with a context on the next line:
  • WARNING: connection not open
  • CONTEXT: while executing command on localhost:xxxxx
• [ ] 2 tests where failures seem to be related to gpid values
  • [ ] isolation_citus_dist_activity

 step s3-view-worker: 
  SELECT query, citus_nodename_for_nodeid(citus_nodeid_for_gpid(global_pid)), citus_nodeport_for_nodeid(citus_nodeid_for_gpid(global_pid)), state, wait_event_type, wait_event, usename, datname FROM citus_stat_activity WHERE query NOT ILIKE ALL(VALUES('%pg_prepared_xacts%'), ('%COMMIT%'), ('%csa_from_one_node%')) AND is_worker_query = true AND backend_type = 'client backend' ORDER BY query DESC;
 
-query                                                                                                      |citus_nodename_for_nodeid|citus_nodeport_for_nodeid|state              |wait_event_type|wait_event|usename |datname
----------------------------------------------------------------------
-SELECT worker_apply_shard_ddl_command (1300009, 'public', '
-    ALTER TABLE test_table ADD COLUMN x INT;
-')|localhost                |                    57636|idle in transaction|Client         |ClientRead|postgres|regression
-SELECT worker_apply_shard_ddl_command (1300008, 'public', '
-    ALTER TABLE test_table ADD COLUMN x INT;
-')|localhost                |                    57636|idle in transaction|Client         |ClientRead|postgres|regression
-SELECT worker_apply_shard_ddl_command (1300007, 'public', '
-    ALTER TABLE test_table ADD COLUMN x INT;
-')|localhost                |                    57636|idle in transaction|Client         |ClientRead|postgres|regression
-SELECT worker_apply_shard_ddl_command (1300006, 'public', '
-    ALTER TABLE test_table ADD COLUMN x INT;
-')|localhost                |                    57636|idle in transaction|Client         |ClientRead|postgres|regression
-(4 rows)
-
+ERROR:  originator node of the query with the global pid 999999990000003827 is not in Citus' metadata

• [ ] isolation_get_distributed_wait_queries_mx

step s3-show-actual-gpids: 
  SELECT global_pid > 0 as gpid_exists, query FROM citus_stat_activity WHERE state = 'active' AND query IN (SELECT blocked_statement FROM citus_lock_waits UNION SELECT current_statement_in_blocking_process FROM citus_lock_waits) ORDER BY 1 DESC;
 
 gpid_exists|query                                                    
 -----------+---------------------------------------------------------
-f          |
+t          |