Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id F2323131F6D2 for ; Fri, 16 Mar 2012 10:19:57 -0300 (ADT) Received: from sss.pgh.pa.us ([66.207.139.130]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1S8X4V-0005lJ-DX for pgsql-admin@postgresql.org; Fri, 16 Mar 2012 13:19:57 +0000 Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id q2GDJaj8006789; Fri, 16 Mar 2012 09:19:36 -0400 (EDT) To: "Marc Mamin" cc: pgsql-admin@postgresql.org Subject: Re: ALTER ROLE foo SET log_connections = true; In-reply-to: References: Comments: In-reply-to "Marc Mamin" message dated "Fri, 16 Mar 2012 12:54:14 +0100" Date: Fri, 16 Mar 2012 09:19:36 -0400 Message-ID: <6788.1331903976@sss.pgh.pa.us> From: Tom Lane X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201203/98 X-Sequence-Number: 39286 "Marc Mamin" 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