pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedALTER ROLE foo SET log_connections = true;
3+ messages / 3 participants
[nested] [flat]
* ALTER ROLE foo SET log_connections = true;
@ 2012-03-16 11:54 Marc Mamin <M.Mamin@intershop.de>
0 siblings, 2 replies; 3+ messages in thread
From: Marc Mamin @ 2012-03-16 11:54 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: ALTER ROLE foo SET log_connections = true;
@ 2012-03-16 12:02 Raghavendra <raghavendra.rao@enterprisedb.com>
parent: Marc Mamin <M.Mamin@intershop.de>
1 sibling, 0 replies; 3+ messages in thread
From: Raghavendra @ 2012-03-16 12:02 UTC (permalink / raw)
To: Marc Mamin <M.Mamin@intershop.de>; +Cc: pgsql-admin
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/
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
>
>
>
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: ALTER ROLE foo SET log_connections = true;
@ 2012-03-16 13:19 Tom Lane <tgl@sss.pgh.pa.us>
parent: Marc Mamin <M.Mamin@intershop.de>
1 sibling, 0 replies; 3+ messages in thread
From: Tom Lane @ 2012-03-16 13:19 UTC (permalink / raw)
To: Marc Mamin <M.Mamin@intershop.de>; +Cc: 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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2012-03-16 13:19 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2012-03-16 11:54 ALTER ROLE foo SET log_connections = true; Marc Mamin <M.Mamin@intershop.de>
2012-03-16 12:02 ` Raghavendra <raghavendra.rao@enterprisedb.com>
2012-03-16 13:19 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox