You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
-
Hi!
If possible, a small question on PGWATCH2 - Postgresql
PGWATCH2 - Running in Docker:
-p 3000:3000 -p 8080:8080 -p 5432:5432
-e PW2_TESTDB=true
-e PW2_PG_RETENTION_DAYS=1
-v "/home/pgwatch2_data/pgwatch2/persistent-config":/pgwatch2/persistent-config
-v "/home/pgwatch2_data/postgresql":/var/lib/postgresql
-v "/home/pgwatch2_data/grafana":/var/lib/grafana
-v "/home/pgwatch2_data/etc/postgresql/postgresql.conf":/etc/postgresql/15/main/postgresql.conf
-v "/home/pgwatch2_data/etc/postgresql/pg_hba.conf":/etc/postgresql/15/main/pg_hba.conf
-v "/home/pgwatch2_data/etc/grafana/grafana.ini":/etc/grafana/grafana.ini
cybertec/pgwatch2-postgres:latest
Question on -e pw2_pg_retention_days = 1
1.
How to realistically check the work of retention
So far I do this way:
\ c pgwatch2_metrics
SELECT DISTINCT DATE (TIME) AS DATE
From public.stat_activity
Order by Date;
If in the Buddhile database, then after installing PW2_PG_RECTION_DAYS = 1
Will old records be deleted? Does this apply only to new ones?
Is the Go script that can delete the data over a period of time,
And most importantly, is there any documentation on retention? Because the official is very swampy.
Thank you, and I hope for help.
Beta Was this translation helpful? Give feedback.
All reactions