[prev in list] [next in list] [prev in thread] [next in thread]
List: postgresql-admin
Subject: Re: [ADMIN] FATAL 1: SetUserId:
From: Bernd Johannes Wuebben <wuebben () math ! cornell ! edu>
Date: 1998-08-14 6:24:45
[Download RAW message or body]
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
--------------------------------------------------------------------
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic