Re: can't alter user with the postgres user

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