Re: Set a specific database to log_statement='ddl' but others to be log_statement='all'

2021-02-15 Thread Abdul Qoyyuum
Thanks David. I tried that and this is what I get: Feb 16 11:27:23 db1 postgres[27675]: [3595-1] etx_ecom> LOG: connection authorized: user=username database=etx_ecom Feb 16 11:27:23 db1 postgres[26184]: [3598-1] core> LOG: disconnection: session time: 0:00:47.727 user=username database=core hos

Re: Set a specific database to log_statement='ddl' but others to be log_statement='all'

2021-02-15 Thread David G. Johnston
On Monday, February 15, 2021, Abdul Qoyyuum wrote: > Hi all, > > I have a Postgresql cluster with master and multiple slaves running on > version 9.6. I'm trying to adjust the log_statement from all to ddl on > specific databases (i.e. postgresql.conf has log_statement='all' but I need > a couple

Set a specific database to log_statement='ddl' but others to be log_statement='all'

2021-02-15 Thread Abdul Qoyyuum
Hi all, I have a Postgresql cluster with master and multiple slaves running on version 9.6. I'm trying to adjust the log_statement from all to ddl on specific databases (i.e. postgresql.conf has log_statement='all' but I need a couple of databases set to log_statement='ddl'). etx_ecom=# ALTER DAT