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

I added it to the path
  • Comment on Re^3: Installing DBD::Pg on Windows XP Pro 32b

Replies are listed 'Best First'.
Re^4: Installing DBD::Pg on Windows XP Pro 32b
by deMize (Monk) on Sep 06, 2009 at 19:06 UTC
    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>

    [download]
    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.
[reply]
[d/l]
      POSTGRES_INCLUDE: C:/PROGRA~2/POSTGR~1/8.4/include
POSTGRES_LIB: C:/PROGRA~2/POSTGR~1/8.4/lib

      [download]

      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');

      [download]
[reply]
[d/l]
[select]
      path %path%;c:\progs\PostgreSQL\8.4\lib

      [download]

      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.

[reply]
[d/l]
        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

        [download]
        Still get the "No libpq libraries were detected!" message :(
[reply]
[d/l]

In Section Seekers of Perl Wisdom