Well, I don't really know how to check for ident map for the user 'postgres' but i think i figured out that the answer to this questions lies somewhere in the pg_hba.conf file..<br>following is the output of my pg_hba.conf file...<br>
-------------------------------------------------------------------------------------------------------------<br># Database administrative login by UNIX sockets<br>local all postgres ident sameuser<br>
<br># TYPE DATABASE USER CIDR-ADDRESS METHOD<br><br># "local" is for Unix domain socket connections only<br>local all all ident sameuser<br># IPv4 local connections:<br>
host all all <a href="http://127.0.0.1/32">127.0.0.1/32</a> md5<br># IPv6 local connections:<br>host all all ::1/128 md5<br>host dspace dspace <a href="http://127.0.0.1">127.0.0.1</a> <a href="http://255.255.255.255">255.255.255.255</a> md5<br>
-------------------------------------------------------------------------------------------------------------<br><br>Could anyone help me to figure out the solution of the problem..<br><br>Regards,<br>Shashank Sahni...<br>
<br><br><div class="gmail_quote"><span dir="ltr"></span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><br>
If Ident authentication failed, then PostgreSQL asked your host OS<br>
what user sent the message containing the command, and the answer to<br>
that question was not what it expected. Check the ident map for user<br>
'postgres' running on the host from which you issued the command.<br>
Make certain that the OS user account you are using will be mapped to<br>
the 'postgres' DBMS user account. Also check to be sure that the host<br>
is running an Ident daemon and that it is configured and operating<br>
correctly.<br>
<br>
The "create new roles" question should not be related to the problem<br>
you have reported. Either policy will do as far as DSpace is<br>
concerned, so I would recommend "no".<br>
<br>
--<br>
Mark H. Wood, Lead System Programmer mwood@IUPUI.Edu<br>
Typically when a software vendor says that a product is "intuitive" he<br>
means the exact opposite.<br>
<br>
-------------- next part --------------<br>
A non-text attachment was scrubbed...<br>
Name: not available<br>
Type: application/pgp-signature<br>
Size: 197 bytes<br>
Desc: not available<br>
Url : <a href="http://mailman.mit.edu/pipermail/dspace-general/attachments/20081021/6e5420ed/attachment-0001.bin" target="_blank">http://mailman.mit.edu/pipermail/dspace-general/attachments/20081021/6e5420ed/attachment-0001.bin</a><br>
<br>
------------------------------<br>
<br>
_______________________________________________<br>
Dspace-general mailing list<br>
<a href="mailto:Dspace-general@mit.edu">Dspace-general@mit.edu</a><br>
<a href="http://mailman.mit.edu/mailman/listinfo/dspace-general" target="_blank">http://mailman.mit.edu/mailman/listinfo/dspace-general</a><br>
<br>
<br>
End of Dspace-general Digest, Vol 63, Issue 19<br>
**********************************************<br>
</blockquote></div><br>