Re: [ADMIN] FATAL 1: SetUserId:

Hello John,

thanks for your suggestion,

On 13-Aug-98 JOHN COOK wrote:
>
> If you do not have the password for it, log it as 'root', then type
> 'passwd postgres' and enter a new password. Log out and log back in as
> postgres. Then "createuser username". You should be able to log out,

root: su - postgres
[postgres(at)petit pgsql]$ createuser wuebben
Connection to database 'template1' failed.
FATAL 1: SetUserId: user "postgres" is not in "pg_shadow"
createuser: database access failed.
[postgres(at)petit pgsql]$

but it still doesn't work. How do I get anyone into pg_shadow?

Bernd

--------------------------------------------------------------------
Bernd Johannes Wuebben wuebben(at)kde(dot)org
wuebben(at)math(dot)cornell(dot)edu wuebben(at)acm(dot)org
--------------------------------------------------------------------