Postgres Pro
Downloads
Home   >   mailing lists

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

From Siraj G
Subject Re: Detect who ran DROP schema
Date
Msg-id CAC5iy61v7-rSvFzg0Ah7wLk-QPU_QY43NkvAuOch3fzGTi7msg@mail.gmail.com
Whole thread Raw
In response to Re: Detect who ran DROP schema  (Muhammad Imtiaz <imtiazpg712@gmail.com>)
Responses Re: Detect who ran DROP schema
List pgsql-admin
Tree view
Hi Imtiaz

I could see this from the log, but not sure from which client or the tool/program the drop was issued.

2024-07-18 14:34:50.044 UTC [774513]: [3-1] db=umarslog,user=postgres STATEMENT:  DROP SCHEMA public CASCADE

On Wed, Jul 24, 2024 at 1:01 PM Muhammad Imtiaz <imtiazpg712@gmail.com> wrote:

Hi,

Please check the database server logs for the drop schema command. This should provide details about the user and the session origin. Configurations like log_connections = on and log_statement = 'all' are recommended to capture the required details in db server logs.



Muhammad Imtiaz

PostgreSQL Technical Support Lead / Pakistan R&D

Mobile: +923345072521


On Wed, Jul 24, 2024 at 12:14 PM Siraj G <tosiraj.g@gmail.com> wrote:
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

pgsql-admin by date:

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