Обсуждение: User specific log file in Postgres

Поиск
Список
Период
Сортировка

User specific log file in Postgres

От
Daulat
Дата:
Hello Team,

Is it possible to set up individual logging files for specific users in Postgresql?

Please suggest !

Thanks

Re: User specific log file in Postgres

От
hubert depesz lubaczewski
Дата:
On Tue, Nov 23, 2021 at 05:24:23PM +0530, Daulat wrote:
> Is it possible to set up individual logging files for specific users in
> Postgresql?

Technically yes. Practically - no.

You could redirect logs to syslog, and make syslog filter messages based
on user, but it's unlikely to work well.

Best regards,

depesz




RE: User specific log file in Postgres

От
"Michel SALAIS"
Дата:

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@msym.fr

www.msym.fr

 

De : Daulat <daulat.dba@gmail.com>
Envoyé : mardi 23 novembre 2021 12:54
À : pgsql-admin@lists.postgresql.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

 

Re: User specific log file in Postgres

От
Dan Smith
Дата:
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@msym.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@msym.fr

www.msym.fr

 

De : Daulat <daulat.dba@gmail.com>
Envoyé : mardi 23 novembre 2021 12:54
À : pgsql-admin@lists.postgresql.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

 

Re: User specific log file in Postgres

От
Daulat
Дата:
Thanks Dan Smith,
Will it log queries executed from PGADMIN? I think no.

Regards,


On Wed, Nov 24, 2021 at 12:45 AM Dan Smith <j.daniel.smith1@gmail.com> wrote:
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@msym.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@msym.fr

www.msym.fr

 

De : Daulat <daulat.dba@gmail.com>
Envoyé : mardi 23 novembre 2021 12:54
À : pgsql-admin@lists.postgresql.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