Re: ALTER ROLE foo SET log_connections = true;

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Marc Mamin" <M(dot)Mamin(at)intershop(dot)de>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: ALTER ROLE foo SET log_connections = true;
Date: 2012-03-16 13:19:36
Message-ID: 6788.1331903976@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Marc Mamin" <M(dot)Mamin(at)intershop(dot)de> writes:
> 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 ...

> 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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message masterchief 2012-03-18 04:29:04 Warnings in Standby Logs
Previous Message Raghavendra 2012-03-16 12:02:52 Re: ALTER ROLE foo SET log_connections = true;