PgAudit: Open-Source PostgreSQL Audit Logging | Hacker News Reader

PgAudit: Open-Source PostgreSQL Audit Logging

github.com

32 pointskvaranasi_9 comments

Im slowly sliding into the opinion that Postgres should go down as the most impactful technology of the 2000s.

Whatever they've done internally to encourage and enable the high quality plugins deserves some seriously high praise.

Dude, seriously. I have been a developer since 2014 but I always stayed away from Postgres because it did not seem cool to me. Recently I started a company which provides Postgres deployments(ironically, just to seem cool) and that's when I unearthed a ton of incredibly powerful features in Postgres. I even wrote a small script that auto inserts user_id from users table into messages table whenever a new message is inserted into the db using Postgres triggers. I mean how cool is that.

Check it out here: https://gist.github.com/kaushik94/5257f0ff5520598e6327d14805...

Everyday I am finding more and more amazing stuff about Postgres and I'm literally obsessed.

If you want to know more about my work, connect with me here: https://twitter.com/RGraphql

You’ve been a developer since and 2014 and hear about database triggers just now? I guess you stayed away not just from Postgres but relational databases in general.

That's true. Been into frontend mostly.

I started webdev (or webapp dev or what ever it was called) quite "late" into my career about 13 years ago. At the time ruby+MySQL were the biggest rage. For some reason I was reading that while MySQL was blazing fast, postgres was standards compliant and focusing on being "correct" and thought ful about it's evolution. I even (may be naively) reasoned that, this deliberate focus + lending itself to better control plane development (I didn't know about control planes at that time but coming from embedded systems had a gut feel about it) were going to be powerful features. Again pure gut feel as I had no web or service dev experience (came from a c++ background).

I am so glad I picked postgres as my db for life when it was not such a cool thing. It has been vindicated time and time again!

Step 1: be free

Lol but true. I was so stuck with mongoDB that I avoided Postgres for far too long and I regret it. It's only now I realise how awesome it is.

Is there some tutorial on how to set up pg_audit? Maybe also something with an interface where the logs can be queried?

I will just show you how big of a mess it is to setup pgAudit on production deployments. TLDR: You can get it soon with Rocketgraph.io.

But I am very obsessed with building loggers using Postgres. There are some sneak peaks of my work on Twitter you can find in the above comment. But it's a lot of work to just setup pgAudit on AWS RDS. Like literally takes days. Basically you have to enable pgAudit, for that you need to edit the DBParameterGroup. Then enable cloudwatchlogs and query from cloudwatch console what logs you want to see. It's a mess. But here is a sneak peek of what's cooking at rocketgraph: https://twitter.com/RGraphql/status/1689631592321544192

It's so beautiful that I'm gonna name it "the sexy release".

Reply on news.ycombinator.com