search

powa-team / powa-archivist

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

Pg 17 support #56

Closed RekGRpth closed 7 months ago

RekGRpth commented 8 months ago

After commit https://github.com/postgres/postgres/commit/13d00729d422c84b1764c24251abcc785ea4adb1 powa does not work with 17 postgres

rjuju commented 8 months ago

Hi,

Yes I also saw that. https://github.com/postgres/postgres/commit/74604a37f2f9eb6e626a4ff3cedd02aef5a2ad59 also probably breaks powa, in a less visible way.

As mentioned in the commit you point out, some more changes are expected in this area. I prefer to wait for the dust to settle a bit before working on the compatibility as it will involve quite some annoying changes in both the extension and UI so I'd rather do it only once.

Note that since you will need pg_stat_io to get the exact same information as before, I will probably fix that only in the (in-progress) v5 version, which adds that data source among other things. If you're interested in testing it, it's available in the "v5" branch of powa-archivist, powa-web and powa-collector projects.

rjuju commented 8 months ago

FYI I just pushed the necessary changes to support pg_stat_statements 1.11, the new pg_stat_checkpointer view and all other changes in pg17. As I mentioned it's only in the dev branch, targeted for the upcoming powa 5 version.

rjuju commented 7 months ago

I'm closing this issue as the necessary work has been done, and will be released in the upcoming v5.