[ADMIN] "pg_guest" is not in "pg_shadow" error. - Mailing list pgsql-admin

From Sejin Oh
Subject [ADMIN] "pg_guest" is not in "pg_shadow" error.
Date
Msg-id 002301bd898b$df76b480$76c708cf@sejinoh.cyberix.com
Whole thread Raw
Responses Re: [ADMIN] "pg_guest" is not in "pg_shadow" error.  (Peter Mount <pgsqladmin@retep.org.uk>)
List pgsql-admin
In my pg_hda.conf:
local        all
password passwd
host         all         127.0.0.1     255.255.255.255   password passwd

then made password file using pg_passwd utility and made pg_guest user:

[postgres@turbo data]$ pg_passwd passwd
Username: pg_guest
New password:
Re-enter new password:

[postgres@turbo data]$ more passwd
pg_guest:BNCVMQvaZsLXs

then when i try to connect to database I get this error message:


[postgres@turbo data]$ psql -u temple
Username: pg_guest
Password:

Connection to database 'temple' failed.
FATAL 1:  SetUserId: user "pg_guest" is not in "pg_shadow"

Can anyone help me what is the solution for this FATAL 1:  SetUserId: user
"pg_guest" is not in "pg_shadow" error?

Thanks in advance.



pgsql-admin by date:

Previous
From: Michael Bishop
Date:
Subject: ...
Next
From: Peter Mount
Date:
Subject: Re: [ADMIN] "pg_guest" is not in "pg_shadow" error.