Re: Detect who ran DROP schema

From: Muhammad Waqas <waqas(dot)m(at)bitnine(dot)net>
To: Siraj G <tosiraj(dot)g(at)gmail(dot)com>
Cc: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Detect who ran DROP schema
Date: 2024-07-30 12:37:46
Message-ID: CAHYHq4W0ohAaTM_jk+27zFr-7kZ9wL4MectsmD_j5KJXn=3r=g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

you can only find by logfile

2024년 7월 24일 (수) 오후 12:14, Siraj G <tosiraj(dot)g(at)gmail(dot)com>님이 작성:

> 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
>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Muhammad Waqas 2024-07-30 12:40:49 Re: wal seams to be corrupted
Previous Message Muhammad Waqas 2024-07-30 12:34:55 Re: Migration from CentOS7 to RHEL red hat Linux