Thread: ...
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.