Re: can't alter user with the postgres user

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@agliodbs.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
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster




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