Re: Help regarding ActiveState's PPM repository module for DBD-pg -- which is currently unavailable!

Am 15.04.2011 21:48, schrieb Lawrence Hixson:

>
> I'm running ActivePerl 5.12.2 and cannot find your driver using their PPM module
> installer.
>
> More research yields this: http://code.activestate.com/ppm/DBD-Pg/ and clicking
> on red ! buttons shows why. I notice that this driver is not available for ANY
> recent ActiveState version and I think it should be.
>
> I found this same situation was true for DBD-mysql, but I intervened and
> connected the module author and ActiveState and at least now the ActiveState
> DBD-mysql driver has some working versions that can be installed and work fine!
> Please see http://code.activestate.com/ppm/DBD-mysql/
>
> Not just for myself, but for the greater ActiveState Perl community, may I
> please ask for your assistance in working with ActiveState to school them on how
> to get your module to compile for their module repositories so more of us can
> use PostgreSQL more fully?
>
> These are two GREAT people at ActiveState who can either help you or direct you
> to those who can help to get your module working with ActivePerl !
>
> Jan Dubois at [email protected]
>
> Jeff Hobbs at [email protected]
>
> If I can be of any other assistance to you, please email me! I plan to attend
> YAPC::NA 2011 in Asheville, North Carolina, USA. I hope some of you will be
> attending!
>
> Sincerely,
> Lawrence K. Hixson

Here is a guide by Mark Dootson posted to this list 2008-02-14.
IIRC I had to edit the makefile and add libpq.lib to
EXTRALIBS and LDLOADLIBS - but that was strawberry/mingw/dmake.

Hth, Christoph

> Not directly helpful for MinGW / Strawberry, but I try to compile all my modules for ActiveState perl with VC6.
>
> I have PostgreSQL 8.3 installed from the msi and I selected to install development files.
>
> The changes I needed to make in DBD::Pg were:
>
> Makefile.PL -
> add 'use DBI::DBD;'.
> comment out "unlink $output->{MAKEFILE};" at line 247
>
> dbdimp.c
> comment out #include <strings.h>
>
> I then used the following statements
>
> 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
>
> before doing
>
> perl Makefile.PL
> nmake
> nmake test
>
>
> All seems to work OK.
>
> I also built against my own perl compiled with VC6. For this I needed an extra step.
> I had to "#define snprintf _snprintf" in quote.c rather than dbdimp.c
>
> I haven't quite figured out why - but there you go.
>
> Anyway, I think that if VC6 is possible, MinGW should be OK too
>
>
> F.Y.I. - Of course, when you run DBD::Pg built this way, you must have libpq.dll and its dependencies on your path.
>
>
>
>
>