I checked into the possibility of tracking DELETE statements in the PostgreSQL database. Unfortunately, since excessive logging isn't enabled, it may be challenging to pinpoint any specific executions. Enabling excessive logging would certainly help, but it does come with performance concerns that we need to consider.
On a positive note, since we have pg_audit installed, we might be able to retrieve the necessary details through that. I can take a closer look at the pg_audit logs to see if they provide the information we need.
0 comments:
Post a Comment