Detect who ran DROP schema

From: Siraj G <tosiraj(dot)g(at)gmail(dot)com>
To: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Detect who ran DROP schema
Date: 2024-07-24 07:14:28
Message-ID: CAC5iy62-OASWAM0vOCcbfZ+04O59cmAdJpZex4KFMmzvr_GjyQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello -

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?

Regards
Siraj

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Muhammad Imtiaz 2024-07-24 07:30:51 Re: Detect who ran DROP schema
Previous Message obi reddy 2024-07-24 06:02:45 Re: pg_basebackup not completing