--On Thursday, August 15, 2002 12:32:16 +0200 "Fabiàn R. Breschi"
<[EMAIL PROTECTED]> wrote:
> After digging more docs, finally found for PG DBI:
>
> DBI:Pg:dbname=mydb;host=Ultra1;port=5432
>
> question 2 still there, thanks.
All you need is the pgsql/lib and pgsql/include directories so that you can
install DBD::Pg.
>
> 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.
>
--
Eric Cholet
