search

powa-team / powa-archivist

powa-archivist: the powa PostgreSQL extension
http://powa.readthedocs.io/
PostgreSQL License
53 stars 20 forks source link

function min(pg_lsn) does not exist #65

Closed RekGRpth closed 3 months ago

RekGRpth commented 3 months ago

after commit 7d1b6ba8772b543af97d73aef4f8f95affa5de8b versions 12 has error

WARNING:  "PoWA".powa_take_snapshot(0): function "PoWA".powa_replication_slots_aggregate failed:
                  state  : 42883
                  message: function min(pg_lsn) does not exist
                  detail : 
                  hint   : No function matches the given name and argument types. You might need to add explicit type casts.
                  context: PL/pgSQL function "PoWA".powa_replication_slots_aggregate(integer) line 12 at SQL statement
    SQL statement "SELECT "PoWA".powa_replication_slots_aggregate(0)"
    PL/pgSQL function "PoWA".powa_take_snapshot(integer) line 128 at EXECUTE

versions 10 and 11 have error

WARNING:  "PoWA".powa_take_snapshot(0): function "PoWA".powa_stat_database_snapshot failed:
                  state  : 42804
                  message: structure of query does not match function result type
                  detail : Returned type integer does not match expected type bigint in column 17.

versions 6.5 and 9.6 have error

 WARNING:  "PoWA".powa_take_snapshot(0): function "PoWA".powa_stat_archiver_snapshot failed:
                  state  : 42883
                  message: function pg_last_wal_receive_lsn() does not exist
                  detail : 
                  hint   : No function matches the given name and argument types. You might need to add explicit type casts.
                  context: PL/pgSQL function "PoWA".powa_stat_archiver_src(integer) line 14 at assignment
rjuju commented 3 months ago

Hi,

Yes I saw that yesterday when I merged the v5. I already fixed it this morning (https://github.com/powa-team/powa-archivist/pull/63) and also fixed pg11 compatibility (https://github.com/powa-team/powa-archivist/pull/64).

rjuju commented 3 months ago

I still have work to do for earlier versions I think, and probably for pg 17 too. I will take care of it this weekend or next weekend.

RekGRpth commented 3 months ago

thank you, versions 10 - 12 are fixed, but 9.5 and 9.6 still have errors

rjuju commented 3 months ago

yes, and 9.4 has a different error too. as I said I'm working on it and it will all be fixed before the beta

rjuju commented 3 months ago

out of curiosity do you still have 9.6 and older version in production?

RekGRpth commented 3 months ago

out of curiosity do you still have 9.6 and older version in production?

no, with powa only 14+

rjuju commented 3 months ago

ok! a fix for EOLed version probably isn't top emergency then.

RekGRpth commented 3 months ago

now it works, thanx

rjuju commented 3 months ago

sorry, I didn't update this issue as pg 9.4 is still broken. I think I will just remove support for this major version though, there are just too many problems (doesn't know about the standard => named parameter, no ASSERT support in plpgsql and no function to get the list of created objects in an event trigger).

RekGRpth commented 3 months ago

typo: I meant NOW it works on 9.5 and 9.6