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(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
>
>
> ---------------------------(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