On Sep 3, 2011, at 7:27 PM, Mr. Puneet Kishor wrote: > I am on Mac OS X Lion with Pg 9.0.x, Perl 5.14.1, and the latest iterations > of DBI and DBD::Pg. My code is pretty straightforward > > my $dbh = DBI->connect("dbi:Pg:dbname=macromap;host=localhost;port=5432", > 'postgres', 'postgres'); > my $sth = $dbh->prepare( .. ); > $sth->execute; > while (my (retrieved columns) = $sth->fetchrow_array) { > do something with retrieved columns > } > > The code bombs with the message: > > DBD::Pg::st execute failed: server closed the connection unexpectedly > This probably means the server terminated abnormally > before or while processing the request. at ...
IIRC, I've seen that when the back end had segfaulted. What do you see in your PostgreSQL log? Best, David