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

From Vincent Veyron
Subject Re: Who altered the database?
Date
Msg-id 20210411170341.8215c3ce4fd6e553c1fc73cf@wanadoo.fr
Whole thread Raw
In response to Who altered the database?  (Durumdara <durumdara@gmail.com>)
List pgsql-general
On Fri, 9 Apr 2021 13:14:17 +0200
Durumdara <durumdara@gmail.com> wrote:
>
> 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.
>

Create a web interface to apply the changes and have the web server log the info in its own logs?

Apache has this directive :

https://httpd.apache.org/docs/2.4/mod/mod_log_config.html#logformat

--
                    Bien à vous, Vincent Veyron

https://marica.fr/
Logiciel de suivi des contentieux juridiques, des sinistres d'assurance et des contrats




pgsql-general by date:

Previous
From: "Abraham, Danny"
Date:
Subject: Reuse of REF Cursor
Next
From: "David G. Johnston"
Date:
Subject: Re: Reuse of REF Cursor