Re: Detect who ran DROP schema

Поиск
Список
Период
Сортировка
От Muhammad Imtiaz
Тема Re: Detect who ran DROP schema
Дата
Msg-id CACW1Ly1wHaB_cGh3Y4RQsXfi8uwcQKLWZ17R4F7vXs9Vpr=svQ@mail.gmail.com
обсуждение исходный текст
Ответ на Detect who ran DROP schema  (Siraj G <tosiraj.g@gmail.com>)
Ответы Re: Detect who ran DROP schema
Список pgsql-admin
Дерево обсуждения

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 по дате отправления: