From http://www.sun.com/bigadmin/features/articles/postgresql_opensolaris.jsp
Did 2. Add the role and profile to database administrators: At least one user must have been assigned the role postgres. The profile is not necessary, because the postgres role has been assigned and all operations could be performed after the role is assumed. The user with the user management permissions (for example, root) can run something similar to the following to assign the role to the user (replace zdenek with the user name): -bash-3.00# usermod -P "Postgres Administration" -R postgres zdenek Except using pfexec so I now need to edit a file owned by root and as I always use pfexec not su will have to find where I wrote the root passwd down :-) Cheers Paul -- This message posted from opensolaris.org
