Hello. Before Apache::DBI installation I'd using just DBI & PgPP for connecting with my PostgreSQL DataBase:
$user = "owner"; $password = "pwd"; $data_source = "dbi:PgPP:mypgdb;localhost;5432"; $dbh = DBI->connect($data_source, $user, $password); $sth = $dbh->prepare( q{ SELECT ... FROM ... }); $rc = $sth->execute; Then I've installed Apache::DBI and modified my httpd.conf. In fact, all the connections to DataBase from the same Perl-scripts became persistent and now total script's work is faster excepting all its initial runnings. For solving this I'd follow the example from the mod_perl mans located here (Preopening DBI connections): ../Apache2/modperl/docs/1.0/guide/databases.html#Preopening_DBI_connections Apache::DBI->connect_on_init ("DBI:mysql:myDB:myserver", "username", "passwd", { PrintError => 1, # warn() on errors RaiseError => 0, # don't die on error AutoCommit => 1, # commit executes immediately } ); strings were added in the startup.pl and the "DBI:mysql:myDB:myserver" string was modified to the "dbi:PgPP:mypgdb:localhost:5432" After server's restart it couldn't to start up actually. The error.log said the following: [Fri Nov 11 21:35:09 2005] [notice] Parent: Received restart signal -- Restarting the server. [Fri Nov 11 21:35:09 2005] [notice] Child 1008: Exit event signaled. Child process is ending. [Fri Nov 11 21:35:10 2005] [notice] Child 1008: Released the start mutex [Fri Nov 11 21:35:12 2005] [error] Can't load Perl file: C:/Program Files/Apache Group/Apache2/conf/startup.pl for server localhost:80, exiting... [Fri Nov 11 21:35:12 2005] [notice] Child 1008: Waiting for 250 worker threads to exit. [Fri Nov 11 21:35:12 2005] [notice] Child 1008: All worker threads have exited. [Fri Nov 11 21:35:12 2005] [notice] Child 1008: Child process is exiting The server's name in the "[error]" string corresponds to the ServerName's value of my httpd.conf. Is there a way to do the Preopening DBI connections just for a PostgreSQL DataBase with Apache::DBI? Thanx.