Re: can't alter user with the postgres user

Ok, I spoke too soon, I think... It seems that pg_user
is a view and shows 8 *'s regardless of what password
you have postgres set up to. I did an 'ALTER USER
postgres WITH PASSWORD 'blah'; ' with the password we
have been using in Webmin for accessing the database,
which interestingly seemed to work (while logged in as
postgres, the message after I pressed 'enter' was
'ALTER USER' then another prompt).

But, I still can't create a user while logged in as
postgres (in Webmin or psql) and webmin isn't picking
up the changes that were made to postgres with 'ALTER
USER'. Perhaps 'ALTER USER' isn't doing what I think
it should be doing??

Still lost

Katy

--- Katy Earl <khaetee(at)yahoo(dot)com> wrote:
> Hi Josh
>
> Yes, I see the problem now.... The password in the
> pg_user table is different from what we are thinking
> postgres's password to be... How do I change the
> password in this table to be the correct one, or
> vice
> versa?
>
> Katy
>
> system=> SELECT * FROM pg_user;
> usename | usesysid | usecreatedb | usesuper
> ----------+----------+-------------+---------
> postgres | 1 | t | f
>
> | usecatupd | passwd | valuntil | useconfig
> +-----------+----------+----------+-----------
> | f | ******** | |
> (1 row)
>
> system=> CREATE USER carl WITH PASSWORD 'moll454';
> ERROR: CREATE USER: permission denied
>
> Katy
>
> --- Josh Berkus <josh(at)agliodbs(dot)com> wrote:
> > Katy,
> >
> > > 2) CREATE USER ...:
> > > Shall the new user be allowed to create
> databases?
> > > (y/n) y
> > > Shall the new user be allowed to create more new
> > > users? (y/n) y
> > > ERROR: CREATE USER: permission denied.
> > > createuser: creation of 'carl' failed.
> >
> > What about doing it from psql?
> >
> > Also from psql:
> >
> > SELECT * FROM pg_user;
> >
> > --
> > -Josh Berkus
> > Aglio Database Solutions
> > San Francisco

__________________________________
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
http://search.yahoo.com