Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group