Postgres Pro
Downloads
Home   >   mailing lists

Re: Detect who ran DROP schema - Mailing list pgsql-admin

From David G. Johnston
Subject Re: Detect who ran DROP schema
Date
Msg-id CAKFQuwabzb1Ozd=oJetThJEkn5iTcCWNOyFTyaBfeCoxZMbxxQ@mail.gmail.com
Whole thread Raw
In response to Re: Detect who ran DROP schema  (Siraj G <tosiraj.g@gmail.com>)
Responses RE: [EXTERNAL] Re: Detect who ran DROP schema
List pgsql-admin
Tree view
On Wednesday, July 24, 2024, Siraj G <tosiraj.g@gmail.com> wrote:

PgSQL instance is a cloud SQL managed by GCP. I used the GCP observability tab to get the log, but I guess more logging is required to get more granular details.

Pretty sure you are sunk if you allow multiple people to connect over IP as the same user.  Though you might be able to locate a client IP address somewhere.

Be glad it was UAT and that you can learn from your mistakes with minimal damage.  Enable better logging and require personal login credentials.

David J.

pgsql-admin by date:

Previous
From: khan Affan
Date:
Subject: Re: Detect who ran DROP schema
Next
From: "Wetmore, Matthew (CTR)"
Date:
Subject: RE: [EXTERNAL] Re: Detect who ran DROP schema