in reply to Re^3: Installing DBD::Pg on Windows XP Pro 32b
in thread Installing DBD::Pg on Windows XP Pro 32b

Ikegami, I'm unsure how you added it to the path. Here is my new output, where I've been getting the similar error. (btw, you are very helpful)
C:\Documents and Settings\vol7ron>cpan Set up gcc environment - 3.4.5 (mingw-vista special r3) cpan shell -- CPAN exploration and modules installation (v1.9402) Enter 'h' for help. cpan> install DBD::Pg Going to read 'C:\Program-Files\Perl\cpan\Metadata' Database was generated on Sat, 05 Sep 2009 09:26:59 GMT Running install for module 'DBD::Pg' Running make for T/TU/TURNSTEP/DBD-Pg-2.15.1.tar.gz Checksum for C:\Program-Files\Perl\cpan\sources\authors\id\T\TU\TURNST +EP\DBD-Pg-2.15.1.tar.gz ok Scanning cache C:\Program-Files\Perl/cpan/build for sizes ...................................................................... +......DONE DBD-Pg-2.15.1/ DBD-Pg-2.15.1/quote.h DBD-Pg-2.15.1/.perlcriticrc DBD-Pg-2.15.1/TODO DBD-Pg-2.15.1/README DBD-Pg-2.15.1/types.c DBD-Pg-2.15.1/Changes DBD-Pg-2.15.1/Makefile.PL DBD-Pg-2.15.1/t/ DBD-Pg-2.15.1/t/00basic.t DBD-Pg-2.15.1/t/08async.t DBD-Pg-2.15.1/t/01constants.t DBD-Pg-2.15.1/t/03smethod.t DBD-Pg-2.15.1/t/01connect.t DBD-Pg-2.15.1/t/03dbmethod.t DBD-Pg-2.15.1/t/06bytea.t DBD-Pg-2.15.1/t/02attribs.t DBD-Pg-2.15.1/t/04misc.t DBD-Pg-2.15.1/t/lib/ DBD-Pg-2.15.1/t/lib/App/ DBD-Pg-2.15.1/t/lib/App/Info.pm DBD-Pg-2.15.1/t/lib/App/Info/ DBD-Pg-2.15.1/t/lib/App/Info/RDBMS/ DBD-Pg-2.15.1/t/lib/App/Info/RDBMS/PostgreSQL.pm DBD-Pg-2.15.1/t/lib/App/Info/Util.pm DBD-Pg-2.15.1/t/lib/App/Info/Request.pm DBD-Pg-2.15.1/t/lib/App/Info/Handler.pm DBD-Pg-2.15.1/t/lib/App/Info/Handler/ DBD-Pg-2.15.1/t/lib/App/Info/Handler/Prompt.pm DBD-Pg-2.15.1/t/lib/App/Info/RDBMS.pm DBD-Pg-2.15.1/t/dbdpg_test_setup.pl DBD-Pg-2.15.1/t/20savepoints.t DBD-Pg-2.15.1/t/07copy.t DBD-Pg-2.15.1/t/09arrays.t DBD-Pg-2.15.1/t/00-signature.t DBD-Pg-2.15.1/t/12placeholders.t DBD-Pg-2.15.1/t/99cleanup.t DBD-Pg-2.15.1/dbivport.h DBD-Pg-2.15.1/Pg.h DBD-Pg-2.15.1/dbdimp.c DBD-Pg-2.15.1/quote.c DBD-Pg-2.15.1/META.yml DBD-Pg-2.15.1/lib/ DBD-Pg-2.15.1/lib/Bundle/ DBD-Pg-2.15.1/lib/Bundle/DBD/ DBD-Pg-2.15.1/lib/Bundle/DBD/Pg.pm DBD-Pg-2.15.1/Pg.xs DBD-Pg-2.15.1/README.win32 DBD-Pg-2.15.1/win32.mak DBD-Pg-2.15.1/MANIFEST DBD-Pg-2.15.1/SIGNATURE DBD-Pg-2.15.1/Pg.pm DBD-Pg-2.15.1/MANIFEST.SKIP DBD-Pg-2.15.1/README.dev DBD-Pg-2.15.1/dbdimp.h DBD-Pg-2.15.1/types.h CPAN.pm: Going to build T/TU/TURNSTEP/DBD-Pg-2.15.1.tar.gz Set up gcc environment - 3.4.5 (mingw-vista special r3) Configuring DBD::Pg 2.15.1 Path to pg_config? C:\Program-Files\PostgreSQL\8.4\bin\pg_config.exe PostgreSQL version: 80400 (default port: 5432) POSTGRES_HOME: (not set) POSTGRES_INCLUDE: C:/PROGRA~2/POSTGR~1/8.4/include POSTGRES_LIB: C:/PROGRA~2/POSTGR~1/8.4/lib OS: MSWin32 Checking if your kit is complete... Looks good Note (probably harmless): No library found for -lpq Using DBI 1.607 (for perl 5.010001 on MSWin32-x86-multi-thread) instal +led in C:/Program-Files/Perl/lib/auto/DBI/ Writing Makefile for DBD::Pg ========================================================== WARNING! No libpq libraries were detected! You need to install the postgresql-libs package for your system, or set the POSTGRES_LIB environment variable to the correct place. Removing (Makefile) =========================================================== Warning: No success on command[C:\Program-Files\Perl\bin\perl.exe Make +file.PL INSTALLDIRS=site] TURNSTEP/DBD-Pg-2.15.1.tar.gz C:\Program-Files\Perl\bin\perl.exe Makefile.PL INSTALLDIRS=site -- N +OT OK Running make test Make had some problems, won't test Running make install Make had some problems, won't install Failed during this command: TURNSTEP/DBD-Pg-2.15.1.tar.gz : writemakefile NO 'C:\P +rogram-Files\Perl\bin\perl.exe Makefile.PL INSTALLDIRS=site' returned + status 256 cpan>
Could you please state how you added it to the path?
I am using "C:\Program-Files\" instead of "C:\Program Files\", so C:/Progra~2/ should be correct. In PostgreSQL\8.4\ there is a "lib" directory and I made sure all the .dll's are listed in there.

Replies are listed 'Best First'.
Re^5: Installing DBD::Pg on Windows XP Pro 32b
by bart (Canon) on Sep 06, 2009 at 19:36 UTC
    POSTGRES_INCLUDE: C:/PROGRA~2/POSTGR~1/8.4/include POSTGRES_LIB: C:/PROGRA~2/POSTGR~1/8.4/lib

    I am using "C:\Program-Files\" instead of "C:\Program Files\", so C:/Progra~2/ should be correct.

    "Should be"? Are you sure? Are you really sure? Because, I wouldn't just trust it.

    When in doubt, you can use the Win32 function GetShortPathName to get the actual short path name.

    use Win32 (); print Win32::GetShortPathName('c:/program files');
Re^5: Installing DBD::Pg on Windows XP Pro 32b
by ikegami (Patriarch) on Sep 06, 2009 at 19:11 UTC
    path %path%;c:\progs\PostgreSQL\8.4\lib

    Still didn't run because it can't find the ssl dll (according to the popup mesage box). Didn't bother looking for that file.

      Forgive me for being such an amateur, where do I type that?

      From a fresh Windows Command Prompt (after clearing the cpan directory), these are the steps I take:
      1) Run cmd from Start->Run 2) type "path %path%;C:\Program-Files\PostgreSQL\8.4\lib" (or whatever + your path is) and hit enter 3) type "cpan" and hit enter 4) type "install DBD::Pg" and hit enter (it'll fetch the files from CP +AN) 5) type "C:\Program-Files\PostgreSQL\8.4\bin\pg_config.exe" (wherever +the pg_config.exe is located) and it enter
      Still get the "No libpq libraries were detected!" message :(
        What popup do you get?