Re: User specific log file in Postgres

Here are a couple of ideas that are outside of the direct question.

I believe you can target one or more users with the pgaudit extension.
Look for Session Audit Logging.
Example "ALTER ROLE role_name SET pgaudit.log = 'all, -misc';".
https://github.com/pgaudit/pgaudit#session-audit-logging

Some clients such as psql will also allow you to write history per host /
user. ~/.psqlrc file add "\set HISTFILE ~/.psql_history_ :HOST _ :USER _
:DBNAME" for example.

Both of these should be well documented and relatively easy to test to see
if they might be of some assistance for you.

Hope this helps.

Best regards,

Dan Smith

On Tue, Nov 23, 2021, 04:52 Michel SALAIS <msalais(at)msym(dot)fr> wrote:

> Hi,
>
>
>
> If you mean the “standard” logging system for PostgreSQL the reply is No.
> Parameter “log_filename” is of context “sighup” and can’t be modified by
> session…
>
>
>
> *Michel SALAIS*
>
> *Consultant Oracle, PostgreSQL*
>
> *MSYM*
>
> *23 rue du Départ*
>
> *Boîte 37*
>
> *75014 Paris*
>
>
>
> *+33 6 68 94 19 60*
>
> *msalais(at)msym(dot)fr <msalais(at)msym(dot)fr>*
>
> *www.msym.fr <http://www.msym.fr/>*
>
>
>
> *De :* Daulat <daulat(dot)dba(at)gmail(dot)com>
> *Envoyé :* mardi 23 novembre 2021 12:54
> *À :* pgsql-admin(at)lists(dot)postgresql(dot)org
> *Objet :* User specific log file in Postgres
>
>
>
> Hello Team,
>
>
>
> Is it possible to set up individual logging files for specific users in
> Postgresql?
>
>
>
> Please suggest !
>
>
>
> Thanks
>
>
>