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

pg exporter will occur error when backup #1091

Open
tunbb opened this issue Nov 14, 2024 · 0 comments
Open

pg exporter will occur error when backup #1091

tunbb opened this issue Nov 14, 2024 · 0 comments

Comments

@tunbb
Copy link

tunbb commented Nov 14, 2024

postgres exporter catch metric pg_pg_replication_lag_seconds,the sql
SELECT CASE WHEN NOT pg_is_in_recovery() THEN 0 ELSE GREATEST (0, EXTRACT(EPOCH FROM (now() - pg_last_xact_replay_timestamp()))) END AS lag

occurs an error every time when backup,
pg_exporter_last_scrape_error = 1

pg_last_xact_replay_timestamp cannot use when backup,so every day we receive an alert

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