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

From Laurenz Albe
Subject Re: Detect who ran DROP schema
Date
Msg-id 0be99bd63697f6a49e2b14c7542c820448ade8e4.camel@cybertec.at
Whole thread Raw
In response to Detect who ran DROP schema  (Siraj G <tosiraj.g@gmail.com>)
List pgsql-admin
On Wed, 2024-07-24 at 12:44 +0530, Siraj G wrote:
> A schema was dropped from our UAT environment on 18th July. We are trying to
> find out who did. We have only one user in our environment, i.e., postgres,
> but we are trying to identify from where the connection was initiated, which
> issued DROP schema. Can anyone help?

Unless you have configured logging, nobody can figure that out.

Among the things you are doing wrong is that you are using a superuser.

Yours,
Laurenz Albe



pgsql-admin by date:

Previous
From: Muhammad Imtiaz
Date:
Subject: Re: Detect who ran DROP schema
Next
From: Laurenz Albe
Date:
Subject: Re: pg_basebackup not completing