Thursday 24 August 2023

New top story on Hacker News: Show HN: I built this Postgres logger for you guys to check out

Show HN: I built this Postgres logger for you guys to check out
5 by kvaranasi_ | 0 comments on Hacker News.
Hey HN, Some of you were really interested in Postgres logging with pgAudit in my previous post here: https://ift.tt/Ktbrk3M So I built this logger: https://ift.tt/Kz10Bay using pgAudit to show you what can be done with Postgres auditing. It offers some powerful features like "get me all the CREATE queries that ran in the past hour". These are generated by AWS RDS Instance running on my Rocketgraph account. Then they are forwarded to Cloudwatch for complex querying. In the future we can connect these logs to slack so you can get slack alerts when a developer accidentally DROPs a table. If you like my work, please check it out here: https://ift.tt/c8VLoGE And if you want this logging on your own Postgres instance. Use https://rocketgraph.io/ And setup a project. pgAudit is automatically installed.

No comments:

Post a Comment