Who altered the database?

From: Durumdara <durumdara(at)gmail(dot)com>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Who altered the database?
Date: 2021-04-09 11:14:17
Message-ID: CAEcMXhk1QXPej=Yn8BCi0Sz+Jh5=v9=RcgMinkhTGwq5xNP+0A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Dear Members!

We have a server.
Because of high usage we can't log DDL-s. There are too many temporary
tables created by users, so it would slow down the server.
A database owner changed.

What can we do to get info about the change (who did it, from what IP, when
it happened) in the future?

As I see we can't define precisely what we want to log... All or nothing.

Do you know any tricks to do it?

For example: DB level trigger, or other thing?

Thank you for the answer!

Best regards

dd

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Glen Huang 2021-04-09 15:05:34 Re: Is replacing transactions with CTE a good idea?
Previous Message hubert depesz lubaczewski 2021-04-09 10:24:00 Re: where clauses including timstamptz and intervals