Re: [ADMIN] FATAL 1: SetUserId: - Mailing list pgsql-admin

From Bernd Johannes Wuebben
Subject Re: [ADMIN] FATAL 1: SetUserId:
Date
Msg-id XFMail.980814022445.wuebben@math.cornell.edu
Whole thread Raw
In response to Re: [ADMIN] FATAL 1: SetUserId:  (JOHN COOK <johncook@interport.net>)
List pgsql-admin
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@petit pgsql]$ createuser wuebben
Connection to database 'template1' failed.
FATAL 1:  SetUserId: user "postgres" is not in "pg_shadow"
createuser: database access failed.
[postgres@petit pgsql]$

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

Bernd

--------------------------------------------------------------------
Bernd Johannes Wuebben                          wuebben@kde.org
wuebben@math.cornell.edu                        wuebben@acm.org
--------------------------------------------------------------------


pgsql-admin by date:

Previous
From: Bernd Johannes Wuebben
Date:
Subject: Re: [ADMIN] FATAL 1: SetUserId:
Next
From: Maarten Boekhold
Date:
Subject: Re: [ADMIN] FATAL 1: SetUserId: