Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Doesn't work with PostgreSQL 17 #21

Open
maxpain opened this issue Nov 3, 2024 · 0 comments
Open

Doesn't work with PostgreSQL 17 #21

maxpain opened this issue Nov 3, 2024 · 0 comments

Comments

@maxpain
Copy link

maxpain commented Nov 3, 2024

Hello. coroot-pg-agent doesn't support the new 17 version of PostgreSQL.
I'm getting these errors:

W1103 10:15:39.258225       1 collector.go:174] 10.244.2.89:5432: pq: column s.blk_read_time does not exist
W1103 10:15:40.261245       1 collector.go:174] 10.244.1.82:5432: pq: column s.blk_read_time does not exist
W1103 10:15:41.260397       1 collector.go:174] 10.244.0.181:5432: pq: column s.blk_read_time does not exist

See: https://www.postgresql.org/docs/current/release-17.html#RELEASE-17-MIGRATION

Rename I/O block read/write timing statistics columns of [pg_stat_statements](https://www.postgresql.org/docs/current/pgstatstatements.html) (Nazir Bilal Yavuz) [git](https://postgr.es/c/13d00729d)
This renames blk_read_time to shared_blk_read_time, and blk_write_time to shared_blk_write_time.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant