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

From Ron
Subject Re: Who altered the database?
Date
Msg-id 3b0705db-1874-0ddf-ac20-3dcd7c494c4b@gmail.com
Whole thread Raw
In response to Who altered the database?  (Durumdara <durumdara@gmail.com>)
List pgsql-general
On 4/9/21 6:14 AM, Durumdara 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?

pg_audit?

-- 
Angular momentum makes the world go 'round.



pgsql-general by date:

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