Guten Tag Tom Lane, Am Montag, 22. April 2002 um 19:56 schrieben Sie:
TL> Denny-Schierz <[EMAIL PROTECTED]> writes: >> testlinux:/home/amphora2/inst# su www-data -s /bin/bash -c 'psql amphora2 < >amphora2.0.dump' >> psql: FATAL 1: IDENT authentication failed for user "www-data" >> local amphora2 ident amphora >> local all ident sameuser >> host all 127.0.0.1 255.0.0.0 ident sameuser >> host all 0.0.0.0 0.0.0.0 reject TL> Did you provide an ident map called amphora? If so, what users does it TL> accept? TL> I suspect you really want to remove that first pg_hba line, and let the TL> "ident sameuser" policy apply to local connections to all databases. TL> regards, tom lane i did only this, what stands in the INSTALL ( http://devel.itmeedia.ee/beta/INSTALL ) from amphopra, i never used postgres before. If i'm understand the pg_ident.conf, it maps from the www-data user (unix user) to the amphora user (postgres in template 1). So i think, that the postgres user amphora has no rights to the amphora2DB, allright? How can i resolve it.? cu -- Mit freundlichen Grüssen Denny-Schierz mailto:[EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
