On Thu, Aug 19, 2021 at 11:41 AM Julien Rouhaud 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.
>
Th
On Thu, Aug 19, 2021 at 1:55 PM Jayadevan M 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 yo
On Wed, Aug 18, 2021 at 9:36 PM Bruce Momjian 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
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'
> D
Hello all,
A doubt on the setting 'log_statement'. Is it possible to set this at
database/user level?
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 pur
