Christian,
What does your "pg_hba.conf" file look like? If you haven't made any
changes in there, for where/who/how is allowed to connect to this
postgreSQL db instance, it's possible that's the first place to start.
Second, it looks like in your connect string, you haven't identified a
host to connect to.
("DBI:Pg:dbname=test2;host=HOSTNAME;port=PORT_IF_OTHER_THAN_5432",
"postgres"... seems correct)
Those would be the first two places to check. Let me know how:
1) you have/have not configured the pg_hba.conf file
2) from where is script executing from? (remote - TCP socket -, local
UNIX/Windows file socket)
Regards,
Christian Stalp wrote:
Hello,
I have some trouble connecting my PostgreSQL-Server.
When I execute this small script:
#!/usr/bin/perl
use warnings;
use strict;
use DBI;
my $dbh = DBI->connect ("DBI:Pg:dbname=test2", "postgres", "wunderbar")
or die "Keine Verbindung mit der DB!\n";
exit;
I get this error:
DBI connect('dbname=test2','postgres',...) failed: FATAL:
Ident-Authentifizierung für Benutzer »postgres« fehlgeschlagen
at ./postgre_test_1.pl line 8
Keine Verbindung mit der DB!
What I have to change for the Cluster? Where are the changes? What I have to
consider, and can I use your PostgreSQL-Server without the cluster?
Thank you.
Gruss Christian
