Postgres Logger

I used pgAudit to setup logging on my AWS RDS Postgres instance.

Disclaimer

I built (Rocketgraph)(https://rocketgraph.io/) which provides a complete backend. That includes Authentication, Hasura console for GraphQL, Postgres DB and serverless functions. So it let's you build web applications in minutes rather than in weeks.

see it in action

Try it out

Rocketgraph hosted

You can signup on Rocketgraph and create a project. The first project is free for 7 days and doesn't require CC.

This spins up a Postgres DB on AWS RDS instance with pgAudit configured.

Then, follow these steps to enable pgAudit:

Login to your RDS Postgres using psql like so:

psql postgresql://postgres:password@project-name.xxxxxxx.us-east-2.rds.amazonaws.com:5432/postgres

Provided in your Rocketgraph dashboard

Create a role:

CREATE ROLE rds_pgaudit; 

Then set log level:

ALTER DATABASE postgres set pgaudit.log="ALL"; 

And enable extension:

CREATE EXTENSION pgAudit;

self-hosted

To use pgAudit on your own Postgres instance, I wrote a detailed article here to setup: https://blog.rocketgraph.io/posts/install-pgaudit

Rocketgraph is open-source. Don't forget to star us here: https://github.com/RocketsGraphQL/rgraph