Re: Trying to install DBD::Pg on Windows XP

I might have to check what quoting the database name in DBI_DSN
does...(that and using db= rather than database=)

Me: # DBI_DSN                     dbi:Pg:database=testdb
You: # DBI_DSN                     dbi:Pg:db="testdb"

(That and you're using one version back...)

As I said, it didn't work for me earlier.  Will try again tomorrow.

--Curtis

On Mon, 18 May 2009 22:49 +0200, "Lamprecht"
<[email protected]> wrote:
> Greg Sabino Mullane wrote:
> > -----BEGIN PGP SIGNED MESSAGE-----
> > Hash: RIPEMD160
> > 
> > 
> >> The directions in the README got me a DBD::Pg that could not connect to
> >> a database at all... (the tests should not pass if it does that!)
> > 
> > Yes, those directions are outdated and need to be updated. So feel free
> > to submit a patch! We have very few people on the list running Windows,
> > thus it doesn't get as much attention as the *nix side of things.
> > 
> 
> Hi,
> 
> these instructions still work perfect. To be sureI just built DBD::Pg
> with 
> strawberry 5.10.4 following Mark Dootsons recipe:
> 
> > Makefile.PL -
> > add 'use DBI::DBD;'.
> > comment out "unlink $output->{MAKEFILE};" at line 247
> > 
> > set required environment:
> > 
> > set PATH=C:\PROGRA~1\PostgreSQL\8.3\bin;%PATH%
> > set DBI_DSN=dbi:Pg:dbname=testdb
> > set DBI_USER=username
> > set DBI_PASS=password
> > set POSTGRES_HOME=C:/PROGRA~1/PostgreSQL/8.3
> > set POSTGRES_INCLUDE=C:/PROGRA~1/PostgreSQL/8.3/include
> > set POSTGRES_LIB=C:/PROGRA~1/PostgreSQL/8.3/lib
> > 
> > 
> > perl Makefile.PL
> > 
> > Now here's the ugly bit: edited both EXTRALIBS and LDLOADLIBS in the resulting Makefile to include 
> > C:\PROGRA~1\PostgreSQL\8.3\lib\libpq.lib
> > 
> > then
> > 
> > dmake
> > dmake test
> > 
> > all works fine.
> 
> (See attached file)
> I had an error related to File::Temp and one failing test in connect.t
> which 
> might be related to my local configuration - I didn't examine further.
> 
> Regards, Christoph

--
Curtis Jewell
[email protected]

%DCL-E-MEM-BAD, bad memory
-VMS-F-PDGERS, pudding between the ears

[I use PC-Alpine, which deliberately does not display colors and
pictures in HTML mail]
--
Curtis Jewell
[email protected]

%DCL-E-MEM-BAD, bad memory
-VMS-F-PDGERS, pudding between the ears

[I use PC-Alpine, which deliberately does not display colors and pictures in HTML mail]