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