Re: Detect who ran DROP schema

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Siraj G <tosiraj(dot)g(at)gmail(dot)com>, Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Detect who ran DROP schema
Date: 2024-07-24 07:34:58
Message-ID: 0be99bd63697f6a49e2b14c7542c820448ade8e4.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Laurenz Albe 2024-07-24 07:38:43 Re: pg_basebackup not completing
Previous Message Muhammad Imtiaz 2024-07-24 07:30:51 Re: Detect who ran DROP schema