OfCourse posting the error might help could not connect to server: Connection refused at ./test_pg.pl line 11.
"Dave K" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Hi All, > Well, I did one of those things that makes me ask myself 'What Were You > Thinking!'. A previous post complaining that a particular idiom didn't work > as advertised for DBD::Pg 'inspired' me to upgrade DBI (good), DBD::Pg > (good), then Postgresql itself (this required an upgrade of cygwin along the > way but hey, why not?). With all that said and done I can no longer connect > to Postgres via DBI. The psql interface works. I then reinstalled DBD::Pg > (to ensure the postgres_lib and postgres_include environment variables were > upgraded), but still no joy. > > my $dbname = "template1"; > my $host = "localhost"; > my $port = 5432; > my $user = 'dave'; > my $pgcs = "dbi:Pg:dbname=$dbname;host=$host;port=$port;user=$user;"; > my $dbh = DBI->connect($pgcs) or die "Connect fails to $dbname\nError = ", > $DBI::errstr; > > DBI Version 1.21 > DBD::Pg Version 1.12 > ipc-daemon Version 1.11 > > Any thoughts? > TIA > >
