Three tier computing: suggestion needed for DBI connection.

[Fabián R. Breschi]

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.