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

From Tom Lane
Subject Re: ALTER ROLE foo SET log_connections = true;
Date
Msg-id 6788.1331903976@sss.pgh.pa.us
Whole thread Raw
In response to ALTER ROLE foo SET log_connections = true;  ("Marc Mamin" <M.Mamin@intershop.de>)
List pgsql-admin
"Marc Mamin" <M.Mamin@intershop.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

pgsql-admin by date:

Previous
From: Raghavendra
Date:
Subject: Re: ALTER ROLE foo SET log_connections = true;
Next
From: masterchief
Date:
Subject: Warnings in Standby Logs