[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-admin
Subject:    Re: [ADMIN] FATAL 1: SetUserId:
From:       Maarten Boekhold <maartenb () dutepp2 ! et ! tudelft ! nl>
Date:       1998-08-14 10:34:06
[Download RAW message or body]

On Thu, 13 Aug 1998, Bernd Johannes Wuebben wrote:

> 
> On 13-Aug-98 Maarten Boekhold wrote:
> >> wuebben: psql template1
> >> Connection to database 'template1' failed.
> >> FATAL 1:  SetUserId: user "wuebben" is not in "pg_shadow" 
> > 
> > Your $PGDATA/pg_hba.conf is probably telling pgsql to require a 
> > username/password for all databases. Go to the end of this file and 
> > change 'password' to 'trust', and then restart the postmaster. I guess 
> > this is an error in the rpm.
> 
> No, this is not the case, here are the last line of my 
> var/lib/pgsql/pg_hba.conf :
> 
> # By default, allow anything over UNIX domain sockets and localhost.
> 
> local        all                                         trust
> host         all         127.0.0.1     255.255.255.255   trust
> 
> As you can see 'trust' is set.

I must have been asleep when I wrote that mail. PostgreSQL always 
requires a valid username. You should be able to connect to postgres when 
you're logged on as the UNIX user 'postgres' (ie. the postgresql 
superuser). Then you can create other users with 'createuser', or from within
psql with 'CREATE USER'.

Maarten

_____________________________________________________________________________
| TU Delft, The Netherlands, Faculty of Information Technology and Systems  |
|                   Department of Electrical Engineering                    |
|           Computer Architecture and Digital Technique section             |
|                          M.Boekhold@et.tudelft.nl                         |
-----------------------------------------------------------------------------

[prev in list] [next in list] [prev in thread] [next in thread]