Hi Wladek! I think this is not a Perl issue. You should locate and check your PostgreSQL Client Authentication Configuration File: pg_hba.conf.
I suppose you have "ident" authentication activated for the user "postgres". 1. You could try to run your program as OS user "postgres". 2. You could try to add this line to pg_hba.conf: host providers postgres 127.0.0.1/32 md5 3. But since the user "postgres" is usually the superuser, it would be a good idea to create a non-superuser for non-administrative tasks (createuser --help) and use this one to connect to the database. Read the comments in pg_hba.conf and browse chapter "Client Authentication" for further details: http://www.postgresql.org/docs/8.3/interactive/client-authentication.html Good luck, Henning 2009/4/22 Wladek Walek <[email protected]>: > Hi, I've created a program in perl to retrieve data from database in > PostgreSQL, but the output gives me: FATAL: Ident authentification failed > for user "postgres" at line .... > > The script in my program is here: > > my $dbh = DBI->connect("dbi:Pg:dbname=providers;host=localhost", "postgres", > "password", {AutoCommit=>0,RaiseError=>1}); > > ...where providers is name of the db... > > Please help me! :) > Thank you for asnwer > > Wladek Walek, Czech Republic >
