From: | Peter Mount <pgsqladmin(at)retep(dot)org(dot)uk> |
---|---|
To: | Sejin Oh <soh(at)cyberix(dot)com> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: [ADMIN] "pg_guest" is not in "pg_shadow" error. |
Date: | 1998-05-27 18:29:08 |
Message-ID: | Pine.LNX.3.95.980527192702.10915A-100000@retep.org.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On Wed, 27 May 1998, Sejin Oh wrote:
> 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(at)turbo data]$ pg_passwd passwd
> Username: pg_guest
> New password:
> Re-enter new password:
>
> [postgres(at)turbo data]$ more passwd
> pg_guest:BNCVMQvaZsLXs
>
> then when i try to connect to database I get this error message:
>
> [postgres(at)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?
Did you create the user using createuser? (other than creating the entry
in your passwd file)
--
Peter T Mount peter(at)retep(dot)org(dot)uk or petermount(at)earthling(dot)net
Main Homepage: http://www.retep.org.uk
************ Someday I may rebuild this signature completely ;-) ************
Work Homepage: http://www.maidstone.gov.uk Work EMail: peter(at)maidstone(dot)gov(dot)uk
From | Date | Subject | |
---|---|---|---|
Next Message | nm | 1998-05-28 01:44:23 | problems with initdb on netbsd/alpha |
Previous Message | Sejin Oh | 1998-05-27 16:24:06 | [ADMIN] "pg_guest" is not in "pg_shadow" error. |