| From: | Vincent Veyron <vv(dot)lists(at)wanadoo(dot)fr> |
|---|---|
| To: | Durumdara <durumdara(at)gmail(dot)com> |
| Cc: | Postgres General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Who altered the database? |
| Date: | 2021-04-11 15:03:41 |
| Message-ID: | 20210411170341.8215c3ce4fd6e553c1fc73cf@wanadoo.fr |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, 9 Apr 2021 13:14:17 +0200
Durumdara <durumdara(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David G. Johnston | 2021-04-11 15:07:49 | Re: Reuse of REF Cursor |
| Previous Message | Abraham, Danny | 2021-04-11 15:03:00 | Reuse of REF Cursor |