Hello all,
At the moment I'm running Apache 1.3.12+mod_perl 1.27 with PG 7.2.1 via
DBI-DBD on a SS5 Solaris 2.6 machine.
I'd like to separate the database engine from the Apache environment so,
running Apache+mod_perl+DBI+DBD on the front end and PostgreSQL at the
backend (hope I'm right with this particular interpretation of 3tier and
split of modules...)
I have glanced around for DBI connect scenarios but could not find any
useful example.
My questions are:
- How do I setup my connection string from
$dbh=DBI->connect('DBI:Pg:dbname=mydb','login','password') to include in
my 'dbname' the host name i.e. 'dbname=mydb@Ultra1' being Ultra1 a fully
qualified alias into my hosts table,
- Providing the above is possible, I imagine that leaving PG installed
at the front end it could only be useful for 'psql -h Ultra1 mydb' but
not necessarily used for DBI?
Any suggestions are much appreciated.
Fabian.
<mailto:info@htandtnet.it?subject=Info%20from%20your%20email%20message...>
|