Re: [ADMIN] log connections to database

2006-04-05 Thread Ben K.
Yup, this is intended and new in 8.1. You need to REVOKE the privileges before being able to drop the role. Thanks. Ben K. Developer http://benix.tamu.edu ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [ADMIN] log connections to database

2006-04-04 Thread Alvaro Herrera
Ben K. wrote: > 3. dropping a role > > If the user is not the owner of the object, is the following an intended > behavior, or could it be some misconfiguration on my side? (In fact this > seems to give me the list of objects the user has acl on.) > > create group ddd; > grant all on atable to

[ADMIN] log connections to database

2006-04-04 Thread Ben K.
Sorry if these are basic questions. It's postgres 8.1 on unix. 1. logging to database I'd like to log connection authentication info into one of the databases, (it's ok to be on the same server as production server), but the logging configuration in postgresql.conf doesn't seem to cover this s