PostgreSQL 9.6.24 and pg_stat_statements 1.4 - Error pg_stat_replication

[GeoffDBA]

Hello,

I have a setup involving one remote server (this is a POC).

• My repository server is running PostgreSQL 17.2 with Remote Collector 1.3. (Ubuntu 24.04.1)

• My remote server is running PostgreSQL 9.6.24 with pg_stat_statements version 1.4 (the maximum version supported for this PostgreSQL version). (Ubuntu 18.04.2)

Th Powa Archivist version is 5.0.1 on the 2 servers.

On the configuration web page, I encounter the following errors:

Error retrieving datasource data pg_stat_replication: ERREUR: la colonne s.sent_lsn n'existe pas LINE 4: s.backend_start, s.backend_xmin, s.state, s.sent_lsn... ^ QUERY: SELECT now, v_current_lsn, s.pid, s.usename::text AS usename, s.application_name, s.client_addr, s.backend_start, s.backend_xmin, s.state, s.sent_lsn, s.write_lsn, s.flush_lsn, s.replay_lsn, s.write_lag, s.flush_lag, s.replay_lag, s.sync_priority, s.sync_state, s.reply_time FROM (SELECT now() AS now) n LEFT JOIN pg_catalog.pg_stat_replication AS s ON true CONTEXT: fonction PL/pgsql public.powa_stat_replication_src(integer), ligne 23 à RETURN QUERY

Error retrieving datasource data pg_stat_subscription: ERREUR: structure of query does not match function result type DETAIL: Le type unknown renvoyé ne correspond pas au type name attendu dans la colonne 3. CONTEXT: fonction PL/pgsql public.powa_stat_subscription_src(integer), ligne 39 à RETURN QUERY

[rjuju]

hi,

thanks a lot for the report. it does look like there are a few bugs in powa-archivist for on pg9.6

I will look at it and also try to double check all very old versions that we probably don't test in the CI.

[rjuju]

(I transferred the issue to powa-archivist repo, so I'm sure I won't forget about it).