See perldoc DBD::Pg for the correct connect parameters.  Just a question,
where did you get this
DBI->connect("dbi:Pg:dbname=tracker", "dbi:Pg:host=host.our.domain.name");
????????

Ilya Sterin

-----Original Message-----
From: Stephen M. Ford [mailto:[EMAIL PROTECTED]]
Sent: Sunday, May 06, 2001 4:30 PM
To: [EMAIL PROTECTED]
Subject: newbie question


I'm using DBI and DBD::Pg.  When I try and connect to the database, I get
DBI->connect(dbname=tracker) failed: 1 at ./tracker2.pl line 15.  Can
someone tell me where the 1 is defined so I can see what it means?


On the postgres database, I've add the following line to the pg_hba.conf
host         all         xxx.xxx.xxx.xxx 255.255.255.255     trust
where the x's are the actual ip address of the server I am trying to connect
from.  That should allow anyone one from that ip to connect to any database,
right?

And I am using $dbh = DBI->connect("dbi:Pg:dbname=tracker",
"dbi:Pg:host=host.our.domain.name"); in my perl script.

I can telnet to port 5432 and communicate with postgres with errors going to
standard out but nothing showing up in the logs so I know the database is
taking connections at least.

Thanks for the help and sorry for such a basic question.
Stephen

Reply via email to