After digging more docs, finally found for PG DBI:
DBI:Pg:dbname=mydb;host=Ultra1;port=5432
question 2 still there, thanks.
Fabian.
"Fabián R. Breschi" wrote:
> 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.
