Postgres Pro
Downloads
Home   >   mailing lists

Re: ALTER ROLE foo SET log_connections = true; - Mailing list pgsql-admin

From Raghavendra
Subject Re: ALTER ROLE foo SET log_connections = true;
Date
Msg-id CA+h6AhiLP0Fjjg4v+gZh6mfA91=OSPfak9aO1Go034U0J+vyfg@mail.gmail.com
Whole thread Raw
In response to ALTER ROLE foo SET log_connections = true;  ("Marc Mamin" <M.Mamin@intershop.de>)
List pgsql-admin
Tree view
Yep, it cannot be changed at session-level.

http://www.postgresql.org/docs/9.1/static/runtime-config-logging.html 

---
Regards,
Raghavendra
EnterpriseDB Corporation



On Fri, Mar 16, 2012 at 5:24 PM, Marc Mamin <M.Mamin@intershop.de> wrote:

Hello,

if I try to SET log_connections = true

(as super user,  for another role)

 I get the error: parameter "log_connections" cannot be set after connection start.

I find it a bit surprising as this wouldn't  affect the current session.

best regards,

Marc Mamin

 


pgsql-admin by date:

Previous
From: "Marc Mamin"
Date:
Subject: ALTER ROLE foo SET log_connections = true;
Next
From: Tom Lane
Date:
Subject: Re: ALTER ROLE foo SET log_connections = true;