connecting to Postgres with Perl

Question

I have installed Postgres in my machine, and I'm trying to connect to it using Perl.

$database = "heatmap";
$user = "postgres";
$password = "<password>";

#connect to Postgres database
my $db = DBI->connect(
        "DBI:Pg:database=$db;",
        $user,
        $password
) or die "Can't Connect to database: $DBI::errstr\n";

However, I'm getting the following error:

DBI connect('database=;','postgres',...) failed: FATAL:  password authentication failed for user "souzamor" at C:/Users/souzamor/workspace/Parser/Parser.pl line 13.
Can't Connect to database: FATAL:  password authentication failed for user "souzamor"

souzamor is my Windows username. However, I'm trying to connect as postgres. I went ahead and created an user called souzamor in Postgres, but I got:

DBI connect('database=;','souzamor',...) failed: FATAL:  database "user='souzamor'" does not exist at C:/Users/souzamor/workspace/Parser/Parser.pl line 13.
Can't Connect to database: FATAL:  database "user='souzamor'" does not exist

I'm totally new with Postgres. Any ideas? Thanks

ccheneson · Accepted Answer · 2012-06-27 12:45:29Z

6

I think you mean

my $db = DBI->connect(
        "DBI:Pg:database=$database",

instead of

my $db = DBI->connect(
        "DBI:Pg:database=$db;",

Edit

According to this, it should be:

my $dbh = DBI->connect("dbi:Pg:dbname=$database", $user, $password);

answered Jun 27, 2012 at 12:45

ccheneson

49.4k8 gold badges65 silver badges69 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Archmal · Accepted Answer · 2013-11-13 15:31:39Z

0

you want to connect to mysql you said in comment

#connect to MySQL database
my $db = DBI->connect(
        "DBI:Pg:database=$db;",
        $user,
        $password

but somehow why you use DBI::Pg << instead using module DBI::mysql ?

*Pg - PostgreSQL

correct me if my answer is wrong

answered Nov 13, 2013 at 15:31

Archmal

631 silver badge8 bronze badges

1 Comment

cybertextron Over a year ago

Corrected! Plx check it again

Collectives™ on Stack Overflow

connecting to Postgres with Perl

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related