2013/2/8 Andreas Kretschmer <andr...@a-kretschmer.de> > How can i drop a user as SUPERUSER (!) with all privileges? >
According to the docs: http://www.postgresql.org/docs/current/interactive/sql-droprole.html > A role cannot be removed if it is still referenced in any database of the cluster; > an error will be raised if so. Before dropping the role, you must drop all the objects > it owns (or reassign their ownership) and revoke any privileges the role has been > granted. The REASSIGN > OWNED<http://www.postgresql.org/docs/current/interactive/sql-reassign-owned.html> and DROP OWNED<http://www.postgresql.org/docs/current/interactive/sql-drop-owned.html> commands can be useful for this purpose. -- Victor Y. Yegorov