> -----Original Message----- > From: [email protected] On Behalf Of sue > Sent: 29 June 2011 23:20 > To: Trac Users > Subject: [Trac] Removing users from the owner dropdown for > postgres database > > Hi All, > We would like to remove old users from the owner drop down list, and > it seems like this is a common usecase from my searching in this > group. The solution seems to be to remove them directly from the > database, and I've found plenty of examples of how to remove users > from an sqlite3 database, but no examples for a postgres database. > Can anyone out there provide the command? We dont have a lot of > postgres expertise here to lean on. > Thanks! > Sue > Do you need help with the SQL to remove the info or running that SQL against PostgreSQL?
The SQL should be pretty much identical to that for SQLite. You need to remove records from the `session_attribute` and the `session` tables. Something like: DELETE FROM session_attribute WHERE sid='username'; DELETE FROM session WHERE sid='username'; For the latter, I use the pyodbc library and do it from an ipython command line. If you have direct access to the server, you could use the pgAdmin tool instead. I hope that is of some help... ~ mark c -- You received this message because you are subscribed to the Google Groups "Trac Users" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/trac-users?hl=en.
