2011/1/16 Steve Litt <slitt@xxxxxxxxxxxxxxxxxxx>
Hi all,
I've somehow messed up something.
psql super
psql's synopsis is
ÂÂÂÂÂÂ psql [option...] [dbname [username]]
Thus, the call "psql super" connects psql to a database
"super" but since username unspecified it is connected
with current Unix user (which is returned by whois(1)).
So, you should call psql like that
 psql super super
or like that
 psql -U super
In last case psql will be connected to the database "super".
ÂÂÂÂÂÂ psql [option...] [dbname [username]]
Thus, the call "psql super" connects psql to a database
"super" but since username unspecified it is connected
with current Unix user (which is returned by whois(1)).
So, you should call psql like that
 psql super super
or like that
 psql -U super
In last case psql will be connected to the database "super".
psql (8.4.5)
Type "help" for help.
super=> \du+
         List of roles
ÂRole name | Attributes Â| Member of | Description
-----------+-------------+-----------+-------------
Âbobo   Â|       | {}    Â|
Âjunk   Â|       | {}    Â|
Âmyuid   |       | {}    Â|
Âpostgres Â| Superuser  | {}    Â|
     : Create role
     : Create DB
Âslitt   | Create DB  | {}    Â|
Âsuper   | Superuser  | {}    Â|
     : Create role
     : Create DB
super=>
super=> alter user myuid password 'mypass';
ERROR: Âpermission denied
super=>
I don't get it. User super is listed as attributes Superuser, create role and
createdb, so why the lack of permission? This also happened when I was in as
"postgres".
Interestingly, earlier tonight I was changing passwords just fine. I don't
know what happened. Obviously there's a chunk of information I'm missing.
What diagnostic tests can I do to narrow this down?
Thanks
SteveT
Steve Litt
Recession Relief Package
http://www.recession-relief.US
Twitter: http://www.twitter.com/stevelitt
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
--
// Dmitriy.
