Re: [ADMIN] Enabling Windows Authentication

2012-03-16 Thread Christian Ullrich
* Noel Simela wrote: I am working on an Analysis cube that gathers data directly from a Postgres 8.4 db connected via PGNP data source. PGNP is based on libpq, so it should work the same way as for ODBC. Problem is I can't browse the cube because my windows credentials are not authenticated

[ADMIN] ALTER ROLE foo SET log_connections = true;

2012-03-16 Thread Marc Mamin
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

Re: [ADMIN] ALTER ROLE foo SET log_connections = true;

2012-03-16 Thread Raghavendra
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.ma...@intershop.de wrote: ** Hello, if I

Re: [ADMIN] ALTER ROLE foo SET log_connections = true;

2012-03-16 Thread Tom Lane
Marc Mamin m.ma...@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