[ADMIN] ALTER ROLE foo SET log_connections = true;

[Marc Mamin]

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

[Raghavendra]

Yep, it cannot be changed at session-level.

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

---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/

Post by Marc Mamin
**
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

[Tom Lane]

Post by Marc Mamin
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.

Yeah ...

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

Nor would it affect any other session, so the error is to let you know
you're doing something useless/ineffective.

regards, tom lane