[ADMIN] "pg_guest" is not in "pg_shadow" error.

From: "Sejin Oh" <soh(at)cyberix(dot)com>
To: <pgsql-admin(at)postgreSQL(dot)org>
Subject: [ADMIN] "pg_guest" is not in "pg_shadow" error.
Date: 1998-05-27 16:24:06
Message-ID: 002301bd898b$df76b480$76c708cf@sejinoh.cyberix.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(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?

Thanks in advance.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Peter Mount 1998-05-27 18:29:08 Re: [ADMIN] "pg_guest" is not in "pg_shadow" error.
Previous Message Michael Bishop 1998-05-27 14:10:44