Postgres Pro
Downloads
Home   >   mailing lists

Re: Who altered the database? - Mailing list pgsql-general

From Ganesh Korde
Subject Re: Who altered the database?
Date
Msg-id CAPNyb0Wc21g6hvDk2Qshb=u-=N=H+uMf==3WJ+PHhDDx7Ci4AA@mail.gmail.com
Whole thread Raw
In response to Who altered the database?  (Durumdara <durumdara@gmail.com>)
List pgsql-general
Tree view


On Fri, 9 Apr 2021, 4:44 pm Durumdara, <durumdara@gmail.com> wrote:
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



You can use different options in log_line_prefix parameter in postgresql.conf
You can also log connection and disconnection, each has separate parameter in configuration file.

Regards,
Ganesh Korde.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: where clauses including timstamptz and intervals
Next
From: Francisco Olarte
Date:
Subject: Re: where clauses including timstamptz and intervals