am 05.01.2006, um 4:14:24 -0800 mailte First Last folgendes:
>
> i'm trying to use phppgadmin to connect to postgresql and
> except for the 'www-data' account, no other account could
Your Webserver runs with this id, and so you can log in into pg with
this username.
> log on to the database. i tried tweaking all the config
> files (pg_hba.conf, postgresql.conf, etc) but to no avail.
> it always gives me the 'FATAL: IDENT Authentication failed
> for user [username]'.
comment the line in pg_hba.conf
"local all postgres ident sameuser"
and change to:
"local all all trust"
Then you can login with other login name.
You should read this:
http://www.postgresql.org/docs/current/static/client-authentication.html
PS.: please no stupid Top-Posting with Fullquote.
HTH, Andreas
--
Andreas Kretschmer (Kontakt: siehe Header)
Heynitz: 035242/47212, D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
=== Schollglas Unternehmensgruppe ===