From: | "Sejin Oh" <soh(at)cyberix(dot)com> |
---|---|
To: | "Peter Mount" <pgsqladmin(at)retep(dot)org(dot)uk> |
Cc: | <pgsql-admin(at)postgreSQL(dot)org> |
Subject: | Re: [ADMIN] "pg_guest" is not in "pg_shadow" error. |
Date: | 1998-05-28 07:45:14 |
Message-ID: | 001801bd8a0c$8e426b00$47c708cf@sejinoh.cyberix.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hello..
I didn't make user called pg_guest with createuser, I user pg_passwd to
create pg_guest and tried to connect postgreSQL with postgres userid.
:)
-----Original Message-----
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 <pgsql-admin(at)postgreSQL(dot)org>
Date: Wednesday, May 27, 1998 2:35 PM
Subject: Re: [ADMIN] "pg_guest" is not in "pg_shadow" error.
>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 | Boris Bellorini | 1998-05-28 11:39:49 | subscribe |
Previous Message | nm | 1998-05-28 01:44:23 | problems with initdb on netbsd/alpha |