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.