log_statement setting

On Wed, Aug 18, 2021 at 09:34:08PM +0530, Jayadevan M wrote:

Hello all,

A doubt on the setting  'log_statement'. Is it possible to set this at database
/user level?

Sure, ALTER USER/DATABASE ... SET.

I get 'all' when I try
select * from pg_settings where name = 'log_statement'
Does this mean all statements by any user on any database in that server are
getting logged? This is for auditing purposes.

Yes.

--
Bruce Momjian <bruce@momjian.us> https://momjian.us
EDB https://enterprisedb.com

If only the physical world exists, free will is an illusion.

On Wed, Aug 18, 2021 at 9:36 PM Bruce Momjian <bruce@momjian.us> wrote:

On Wed, Aug 18, 2021 at 09:34:08PM +0530, Jayadevan M wrote:

Hello all,

A doubt on the setting 'log_statement'. Is it possible to set this at

database

/user level?

Sure, ALTER USER/DATABASE ... SET.

Thank you. Follow up question- If it is set to different values for
different users/databases, how can I get those values? For example,
I have a server with 4 databases. If I just query pg_settings, I get only
one value.

I get 'all' when I try
select * from pg_settings where name = 'log_statement'
Does this mean all statements by any user on any database in that server

are

getting logged? This is for auditing purposes.

Yes.

Thanks.

On Thu, Aug 19, 2021 at 1:55 PM Jayadevan M <maymala.jayadevan@gmail.com> wrote:

Thank you. Follow up question- If it is set to different values for different users/databases, how can I get those values? For example,
I have a server with 4 databases. If I just query pg_settings, I get only one value.

The value you see on pg_settings is the one that's selected for your
current connection, based on the database/role you used.

You can use \drds in psql to see the various configurations, or query
the pg_db_role_setting table.

On Thu, Aug 19, 2021 at 11:41 AM Julien Rouhaud <rjuju123@gmail.com> wrote:

The value you see on pg_settings is the one that's selected for your
current connection, based on the database/role you used.

You can use \drds in psql to see the various configurations, or query
the pg_db_role_setting table.

Thank you. Pointing to pg_db_role_setting was very helpful. I was able to
get the data I wanted.
Regards,
Jay