Beefy Boxes and Bandwidth Generously Provided by pair Networks
No such thing as a small change
 
PerlMonks  

'cpan DBD::Pg' install fails

by perlygapes (Acolyte)
on Feb 10, 2020 at 03:43 UTC ( #11112712=perlquestion: print w/replies, xml ) Need Help??

perlygapes has asked for the wisdom of the Perl Monks concerning the following question:

Monastic Greetings

StackOverflow Ticket https://stackoverflow.com/questions/60133484/perl-cpan-module-install-fails-dbdpg-postgresql-driver-on-windows7-64-bit-s
CPAN Ticket https://rt.cpan.org/Public/Bug/Display.html?id=131708
Github Ticket (orig.) https://github.com/metacpan/metacpan-web/issues/2266

I have been unable to install the updated version 3.10.4 of DBD::Pg using either:
C:\>cpan DBD::Pg
cpan>install DBD::Pg

I followed the README instructions for Strawberry Perl regarding setting Windows ENVVARS for PostgreSQL and exporting DLL symbols from 'libpq.dll', but it still fails with the following errors:

dbdimp.o:dbdimp.c:(.text+0x479): undefined reference to 'PQstatus'<br> <...etc...etc...>
as per the StackOverflow ticket details.

Doeth anyone carry in their habit a shucking knife?

Your grace is humble sought,
One who possesseth knowledge gaps.

Replies are listed 'Best First'.
Re: 'cpan DBD::Pg' install fails
by syphilis (Bishop) on Feb 10, 2020 at 08:42 UTC
    I followed the README instructions for Strawberry Perl ...

    I didn't follow those instructions - I merely ran cpan -i DBD::Pg
    (Sorry - I didn't pay heed to the significance of that sentence first time round.)

    I would expect that's the reason that my attempt succeeded, but yours didn't.

    Those instructions are apparently old, obsolete and wrong.

    Cheers,
    Rob
Re: 'cpan DBD::Pg' install fails
by syphilis (Bishop) on Feb 10, 2020 at 04:20 UTC
    I have been unable to install the updated version 3.10.4 of DBD::Pg using either:
    C:\>cpan DBD::Pg
    cpan>install DBD::Pg


    On my Windows 7 box, with 64-bit Strawberry Perl perl-5.30.0, DBD-Pg-3.10.4 installed without issue (albeit somewhat noisily) with cpan -i DBD::Pg
    Loading internal logger. Log::Log4perl recommended for better logging Reading 'C:\Users\sisyphus\.cpan\Metadata' Database was generated on Mon, 10 Feb 2020 03:55:09 GMT CPAN: Module::CoreList loaded ok (v5.20190522) Running install for module 'DBD::Pg' CPAN: Digest::SHA loaded ok (v6.02) CPAN: Compress::Zlib loaded ok (v2.086) Checksum for C:\Users\sisyphus\.cpan\sources\authors\id\T\TU\TURNSTEP\ +DBD-Pg-3.10.4.tar.gz ok CPAN: Archive::Tar loaded ok (v2.32) CPAN: YAML loaded ok (v1.29) CPAN: CPAN::Meta::Requirements loaded ok (v2.140) CPAN: Parse::CPAN::Meta loaded ok (v2.150010) CPAN: CPAN::Meta loaded ok (v2.150010) Configuring T/TU/TURNSTEP/DBD-Pg-3.10.4.tar.gz with Makefile.PL Configuring DBD::Pg 3.10.4 PostgreSQL version: 110003 (default port: 5432) POSTGRES_HOME: (not set) POSTGRES_INCLUDE: C:/_64/ST2A67~1.0/c/include POSTGRES_LIB: C:/_64/ST2A67~1.0/c/lib OS: MSWin32 Checking if your kit is complete... Looks good Using DBI 1.642 (for perl 5.030000 on MSWin32-x64-multi-thread) instal +led in C:/_64/strawberry-vanilla-5.30.0/perl/vendor/lib/auto/DBI/ Generating a gmake-style Makefile Writing Makefile for DBD::Pg Writing MYMETA.yml and MYMETA.json TURNSTEP/DBD-Pg-3.10.4.tar.gz C:\_64\strawberry-vanilla-5.30.0\perl\bin\perl.exe Makefile.PL -- OK Running make for T/TU/TURNSTEP/DBD-Pg-3.10.4.tar.gz cp Pg.pm blib\lib\DBD/Pg.pm cp lib/Bundle/DBD/Pg.pm blib\lib/Bundle/DBD/Pg.pm Running Mkbootstrap for Pg () "C:\_64\strawberry-vanilla-5.30.0\perl\bin\perl.exe" -MExtUtils::Comma +nd -e chmod -- 644 "Pg.bs" "C:\_64\strawberry-vanilla-5.30.0\perl\bin\perl.exe" -MExtUtils::Comma +nd::MM -e cp_nonempty -- Pg.bs blib\arch\auto\DBD\Pg\Pg.bs 644 "C:\_64\strawberry-vanilla-5.30.0\perl\bin\perl.exe" -p -e "s/~DRIVER~ +/Pg/g; s/^do\(/dontdo\(/" C:\_64\strawberry-vanilla-5.30.0\perl\vendo +r\lib\auto\DBI\Driver.xst > Pg.xsi "C:\_64\strawberry-vanilla-5.30.0\perl\bin\perl.exe" "C:\_64\strawberr +y-vanilla-5.30.0\perl\lib\ExtUtils/xsubpp" -typemap C:\_64\strawberr +y-vanilla-5.30.0\perl\lib\ExtUtils\typemap Pg.xs > Pg.xsc "C:\_64\strawberry-vanilla-5.30.0\perl\bin\perl.exe" -MExtUtils::Comma +nd -e mv -- Pg.xsc Pg.c gcc -c -I"C:/_64/ST2A67~1.0/c/include" -IC:\_64\strawberry-vanilla-5. +30.0\perl\vendor\lib\auto\DBI -s -O2 -DWIN32 -DWIN64 -DCONSERVATIVE - +D__USE_MINGW_ANSI_STDIO -DPERL_TEXTMODE_SCRIPTS -DPERL_IMPLICIT_CONTE +XT -DPERL_IMPLICIT_SYS -DUSE_PERLIO -fwrapv -fno-strict-aliasing -fdi +agnostics-color=never -mms-bitfields -DPGLIBVERSION=110003 -DPGDEFPOR +T=5432 -s -O2 -DVERSION=\"3.10.4\" -DXS_VERSION=\"3.10.4\" "-IC:\_ +64\strawberry-vanilla-5.30.0\perl\lib\CORE" Pg.c In file included from C:\_64\strawberry-vanilla-5.30.0\perl\vendor\lib +\auto\DBI/DBIXS.h:38, from Pg.h:56, from Pg.xs:14: C:\_64\strawberry-vanilla-5.30.0\perl\vendor\lib\auto\DBI/dbipport.h:4 +471: warning: "WIDEST_UTYPE" redefined # define WIDEST_UTYPE U64TYPE In file included from C:\_64\strawberry-vanilla-5.30.0\perl\lib\CORE/p +erl.h:2508, from C:\_64\strawberry-vanilla-5.30.0\perl\vendor\lib +\auto\DBI/DBIXS.h:23, from Pg.h:56, from Pg.xs:14: C:\_64\strawberry-vanilla-5.30.0\perl\lib\CORE/handy.h:1072: note: thi +s is the location of the previous definition # define WIDEST_UTYPE U64 gcc -c -I"C:/_64/ST2A67~1.0/c/include" -IC:\_64\strawberry-vanilla-5. +30.0\perl\vendor\lib\auto\DBI -s -O2 -DWIN32 -DWIN64 -DCONSERVATIVE - +D__USE_MINGW_ANSI_STDIO -DPERL_TEXTMODE_SCRIPTS -DPERL_IMPLICIT_CONTE +XT -DPERL_IMPLICIT_SYS -DUSE_PERLIO -fwrapv -fno-strict-aliasing -fdi +agnostics-color=never -mms-bitfields -DPGLIBVERSION=110003 -DPGDEFPOR +T=5432 -s -O2 -DVERSION=\"3.10.4\" -DXS_VERSION=\"3.10.4\" "-IC:\_ +64\strawberry-vanilla-5.30.0\perl\lib\CORE" dbdimp.c In file included from C:\_64\strawberry-vanilla-5.30.0\perl\vendor\lib +\auto\DBI/DBIXS.h:38, from Pg.h:56, from dbdimp.c:14: C:\_64\strawberry-vanilla-5.30.0\perl\vendor\lib\auto\DBI/dbipport.h:4 +471: warning: "WIDEST_UTYPE" redefined # define WIDEST_UTYPE U64TYPE In file included from C:\_64\strawberry-vanilla-5.30.0\perl\lib\CORE/p +erl.h:2508, from C:\_64\strawberry-vanilla-5.30.0\perl\vendor\lib +\auto\DBI/DBIXS.h:23, from Pg.h:56, from dbdimp.c:14: C:\_64\strawberry-vanilla-5.30.0\perl\lib\CORE/handy.h:1072: note: thi +s is the location of the previous definition # define WIDEST_UTYPE U64 dbdimp.c: In function 'pg_st_prepare_statement': dbdimp.c:2368:44: warning: cast from pointer to integer of different s +ize [-Wpointer-to-int-cast] if ((0 == imp_dbh->sth_result_owner || (long int)imp_sth == imp_d +bh->sth_result_owner) ^ dbdimp.c:2383:33: warning: cast from pointer to integer of different s +ize [-Wpointer-to-int-cast] imp_dbh->sth_result_owner = (long int)imp_sth; ^ dbdimp.c: In function 'pg_st_execute': dbdimp.c:3404:52: warning: cast from pointer to integer of different s +ize [-Wpointer-to-int-cast] if ((0 == imp_dbh->sth_result_owner || (long int)imp_sth +== imp_dbh->sth_result_owner) ^ dbdimp.c:3419:41: warning: cast from pointer to integer of different s +ize [-Wpointer-to-int-cast] imp_dbh->sth_result_owner = (long int)imp_sth; ^ dbdimp.c:3498:52: warning: cast from pointer to integer of different s +ize [-Wpointer-to-int-cast] if ((0 == imp_dbh->sth_result_owner || (long int)imp_sth +== imp_dbh->sth_result_owner) ^ dbdimp.c:3515:41: warning: cast from pointer to integer of different s +ize [-Wpointer-to-int-cast] imp_dbh->sth_result_owner = (long int)imp_sth; ^ dbdimp.c:3575:52: warning: cast from pointer to integer of different s +ize [-Wpointer-to-int-cast] if ((0 == imp_dbh->sth_result_owner || (long int)imp_sth +== imp_dbh->sth_result_owner) ^ dbdimp.c:3592:41: warning: cast from pointer to integer of different s +ize [-Wpointer-to-int-cast] imp_dbh->sth_result_owner = (long int)imp_sth; ^ dbdimp.c: In function 'pg_st_finish': dbdimp.c:3899:42: warning: cast from pointer to integer of different s +ize [-Wpointer-to-int-cast] if (imp_dbh->sth_result_owner == (long int)imp_sth) { ^ dbdimp.c: In function 'pg_st_destroy': dbdimp.c:4070:10: warning: cast from pointer to integer of different s +ize [-Wpointer-to-int-cast] if ( (long int)imp_sth == imp_dbh->sth_result_owner ) { ^ dbdimp.c: In function 'pg_db_result': dbdimp.c:5233:52: warning: cast from pointer to integer of different s +ize [-Wpointer-to-int-cast] if ((0 == imp_dbh->sth_result_owner || (long int)imp_dbh- +>async_sth == imp_dbh->sth_result_owner) ^ dbdimp.c:5247:41: warning: cast from pointer to integer of different s +ize [-Wpointer-to-int-cast] imp_dbh->sth_result_owner = (long int)imp_dbh->async_sth; ^ dbdimp.c: In function 'pg_st_deallocate_statement.isra.4': dbdimp.c:3965:17: warning: 'strncpy' specified bound depends on the le +ngth of the source argument [-Wstringop-overflow=] strncpy(tempsqlstate, imp_dbh->sqlstate, strlen(imp_d +bh->sqlstate)+1); ^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ +~~~~~~~~~~~~~~~~ dbdimp.c:3965:58: note: length computed here strncpy(tempsqlstate, imp_dbh->sqlstate, strlen(imp_d +bh->sqlstate)+1); ^~~~~~~~~~~~ +~~~~~~~~~~~~~ dbdimp.c:4001:9: warning: 'strncpy' specified bound depends on the len +gth of the source argument [-Wstringop-overflow=] strncpy(imp_dbh->sqlstate, tempsqlstate, strlen(tempsqlstate) ++1); ^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ +~~~ dbdimp.c:4001:50: note: length computed here strncpy(imp_dbh->sqlstate, tempsqlstate, strlen(tempsqlstate) ++1); ^~~~~~~~~~~~~~~~~~~~ gcc -c -I"C:/_64/ST2A67~1.0/c/include" -IC:\_64\strawberry-vanilla-5. +30.0\perl\vendor\lib\auto\DBI -s -O2 -DWIN32 -DWIN64 -DCONSERVATIVE - +D__USE_MINGW_ANSI_STDIO -DPERL_TEXTMODE_SCRIPTS -DPERL_IMPLICIT_CONTE +XT -DPERL_IMPLICIT_SYS -DUSE_PERLIO -fwrapv -fno-strict-aliasing -fdi +agnostics-color=never -mms-bitfields -DPGLIBVERSION=110003 -DPGDEFPOR +T=5432 -s -O2 -DVERSION=\"3.10.4\" -DXS_VERSION=\"3.10.4\" "-IC:\_ +64\strawberry-vanilla-5.30.0\perl\lib\CORE" quote.c In file included from C:\_64\strawberry-vanilla-5.30.0\perl\vendor\lib +\auto\DBI/DBIXS.h:38, from Pg.h:56, from quote.c:10: C:\_64\strawberry-vanilla-5.30.0\perl\vendor\lib\auto\DBI/dbipport.h:4 +471: warning: "WIDEST_UTYPE" redefined # define WIDEST_UTYPE U64TYPE In file included from C:\_64\strawberry-vanilla-5.30.0\perl\lib\CORE/p +erl.h:2508, from C:\_64\strawberry-vanilla-5.30.0\perl\vendor\lib +\auto\DBI/DBIXS.h:23, from Pg.h:56, from quote.c:10: C:\_64\strawberry-vanilla-5.30.0\perl\lib\CORE/handy.h:1072: note: thi +s is the location of the previous definition # define WIDEST_UTYPE U64 gcc -c -I"C:/_64/ST2A67~1.0/c/include" -IC:\_64\strawberry-vanilla-5. +30.0\perl\vendor\lib\auto\DBI -s -O2 -DWIN32 -DWIN64 -DCONSERVATIVE - +D__USE_MINGW_ANSI_STDIO -DPERL_TEXTMODE_SCRIPTS -DPERL_IMPLICIT_CONTE +XT -DPERL_IMPLICIT_SYS -DUSE_PERLIO -fwrapv -fno-strict-aliasing -fdi +agnostics-color=never -mms-bitfields -DPGLIBVERSION=110003 -DPGDEFPOR +T=5432 -s -O2 -DVERSION=\"3.10.4\" -DXS_VERSION=\"3.10.4\" "-IC:\_ +64\strawberry-vanilla-5.30.0\perl\lib\CORE" types.c In file included from C:\_64\strawberry-vanilla-5.30.0\perl\vendor\lib +\auto\DBI/DBIXS.h:38, from Pg.h:56, from types.c:15: C:\_64\strawberry-vanilla-5.30.0\perl\vendor\lib\auto\DBI/dbipport.h:4 +471: warning: "WIDEST_UTYPE" redefined # define WIDEST_UTYPE U64TYPE In file included from C:\_64\strawberry-vanilla-5.30.0\perl\lib\CORE/p +erl.h:2508, from C:\_64\strawberry-vanilla-5.30.0\perl\vendor\lib +\auto\DBI/DBIXS.h:23, from Pg.h:56, from types.c:15: C:\_64\strawberry-vanilla-5.30.0\perl\lib\CORE/handy.h:1072: note: thi +s is the location of the previous definition # define WIDEST_UTYPE U64 "C:\_64\strawberry-vanilla-5.30.0\perl\bin\perl.exe" -MExtUtils::Mksym +lists \ -e "Mksymlists('NAME'=>\"DBD::Pg\", 'DLBASE' => 'Pg', 'DL_FUNCS' +=> { }, 'FUNCLIST' => [], 'IMPORTS' => { }, 'DL_VARS' => []);" g++.exe Pg.def -o blib\arch\auto\DBD\Pg\Pg.xs.dll -mdll -s -L"C:\_64\s +trawberry-vanilla-5.30.0\perl\lib\CORE" -L"C:\_64\strawberry-vanilla- +5.30.0\c\lib" Pg.o dbdimp.o quote.o types.o "C:\_64\strawberry-vani +lla-5.30.0\perl\lib\CORE\libperl530.a" "C:\_64\ST2A67~1.0\c\lib\libpq +.a" "C:\_64\strawberry-vanilla-5.30.0\c\x86_64-w64-mingw32\lib\libm.a +" "C:\_64\strawberry-vanilla-5.30.0\c\x86_64-w64-mingw32\lib\libsecur +32.a" "C:\_64\strawberry-vanilla-5.30.0\c\x86_64-w64-mingw32\lib\libm +oldname.a" "C:\_64\strawberry-vanilla-5.30.0\c\x86_64-w64-mingw32\lib +\libkernel32.a" "C:\_64\strawberry-vanilla-5.30.0\c\x86_64-w64-mingw3 +2\lib\libuser32.a" "C:\_64\strawberry-vanilla-5.30.0\c\x86_64-w64-min +gw32\lib\libgdi32.a" "C:\_64\strawberry-vanilla-5.30.0\c\x86_64-w64-m +ingw32\lib\libwinspool.a" "C:\_64\strawberry-vanilla-5.30.0\c\x86_64- +w64-mingw32\lib\libcomdlg32.a" "C:\_64\strawberry-vanilla-5.30.0\c\x8 +6_64-w64-mingw32\lib\libadvapi32.a" "C:\_64\strawberry-vanilla-5.30.0 +\c\x86_64-w64-mingw32\lib\libshell32.a" "C:\_64\strawberry-vanilla-5. +30.0\c\x86_64-w64-mingw32\lib\libole32.a" "C:\_64\strawberry-vanilla- +5.30.0\c\x86_64-w64-mingw32\lib\liboleaut32.a" "C:\_64\strawberry-van +illa-5.30.0\c\x86_64-w64-mingw32\lib\libnetapi32.a" "C:\_64\strawberr +y-vanilla-5.30.0\c\x86_64-w64-mingw32\lib\libuuid.a" "C:\_64\strawber +ry-vanilla-5.30.0\c\x86_64-w64-mingw32\lib\libws2_32.a" "C:\_64\straw +berry-vanilla-5.30.0\c\x86_64-w64-mingw32\lib\libmpr.a" "C:\_64\straw +berry-vanilla-5.30.0\c\x86_64-w64-mingw32\lib\libwinmm.a" "C:\_64\str +awberry-vanilla-5.30.0\c\x86_64-w64-mingw32\lib\libversion.a" "C:\_64 +\strawberry-vanilla-5.30.0\c\x86_64-w64-mingw32\lib\libodbc32.a" "C:\ +_64\strawberry-vanilla-5.30.0\c\x86_64-w64-mingw32\lib\libodbccp32.a" + "C:\_64\strawberry-vanilla-5.30.0\c\x86_64-w64-mingw32\lib\libcomctl +32.a" -Wl,--enable-auto-image-base "C:\_64\strawberry-vanilla-5.30.0\perl\bin\perl.exe" -MExtUtils::Comma +nd -e chmod -- 755 blib\arch\auto\DBD\Pg\Pg.xs.dll TURNSTEP/DBD-Pg-3.10.4.tar.gz gmake -- OK Running make test for TURNSTEP/DBD-Pg-3.10.4.tar.gz "C:\_64\strawberry-vanilla-5.30.0\perl\bin\perl.exe" -MExtUtils::Comma +nd::MM -e cp_nonempty -- Pg.bs blib\arch\auto\DBD\Pg\Pg.bs 644 "C:\_64\strawberry-vanilla-5.30.0\perl\bin\perl.exe" "-MExtUtils::Comm +and::MM" "-MTest::Harness" "-e" "undef *Test::Harness::Switches; test +_harness(0, 'blib\lib', 'blib\arch')" t/*.t t/00_signature.t ....... skipped: Set the environment variable TEST_SI +GNATURE to enable this test t/00basic.t ............ ok # # DBI Version 1.642 # DBD::Pg Version 3.10.4 # Perl Version 5.30.0 # OS MSWin32 # PostgreSQL (compiled) ? # PostgreSQL (target) ? # PostgreSQL (reported) ? # Default port ? # DBI_DSN ? # DBI_USER <not set> # Test schema dbd_pg_testschema # LANG C # Adjusted: initdb # Error was: Bad initdb output: 'initdb' is not recognized as an inter +nal or external command, # operable program or batch file. # t/01connect.t .......... skipped: Connection to database failed, canno +t continue testing t/01constants.t ........ ok t/02attribs.t .......... skipped: Connection to database failed, canno +t continue testing t/03dbmethod.t ......... skipped: Connection to database failed, canno +t continue testing t/03smethod.t .......... skipped: Connection to database failed, canno +t continue testing t/04misc.t ............. skipped: Connection to database failed, canno +t continue testing t/06bytea.t ............ skipped: Connection to database failed, canno +t continue testing t/07copy.t ............. skipped: Connection to database failed, canno +t continue testing t/08async.t ............ skipped: Connection to database failed, canno +t continue testing t/09arrays.t ........... skipped: Connection to database failed, canno +t continue testing t/10_pg_error_field.t .. skipped: Connection to database failed, canno +t continue testing t/12placeholders.t ..... skipped: Connection to database failed, canno +t continue testing t/20savepoints.t ....... skipped: Connection to database failed, canno +t continue testing t/30unicode.t .......... skipped: Connection to database failed, canno +t continue testing t/99cleanup.t .......... ok All tests successful. Files=17, Tests=168, 9 wallclock secs ( 0.05 usr + 0.01 sys = 0.06 +CPU) Result: PASS TURNSTEP/DBD-Pg-3.10.4.tar.gz gmake test -- OK Running make install for TURNSTEP/DBD-Pg-3.10.4.tar.gz "C:\_64\strawberry-vanilla-5.30.0\perl\bin\perl.exe" -MExtUtils::Comma +nd::MM -e cp_nonempty -- Pg.bs blib\arch\auto\DBD\Pg\Pg.bs 644 Files found in blib\arch: installing files in blib\lib into architectu +re dependent library tree Installing C:\_64\strawberry-vanilla-5.30.0\perl\site\lib\auto\DBD\Pg\ +Pg.xs.dll Appending installation info to C:\_64\strawberry-vanilla-5.30.0\perl\l +ib/perllocal.pod TURNSTEP/DBD-Pg-3.10.4.tar.gz gmake install -- OK
    Absolutely no "undefined reference" at all.

    Cheers,
    Rob
Re: 'cpan DBD::Pg' install fails ( undefined reference to 'PQstatus' , objdump )
by Anonymous Monk on Feb 10, 2020 at 04:19 UTC

    Re: 'cpan DBD::Pg' install fails ( undefined reference to 'PQstatus' , objdump )

    use "objdump" to find it out

    https://www.postgresql.org/docs/8.1/libpq-build.html

    This means you forgot ..

    This means you forgot the -L option or did not specify the right directory.

      Thank you for your supplication. Dark forces are shielding mine eyes from the truth. I do not know how to use objdump (I can run it in Cygwin, but there are many switches). I can do simple tasks, like lookup scripture verse, like this:
      $ find . -type f -name "libpq.dll" -o -name "libpq.def" -o -name "libp +q.[ha]" ./12/bin/libpq.def ./12/bin/libpq.dll ./12/include/server/libpq/libpq.h ./12/lib/libpq.a ./12/lib/libpq.dll ./12/pgAdmin 4/bin/libpq.dll $
      linpq.def and libpq.a were created using pexports and dllname in MinGW, as per my Github Ticket details.

      Of the files listed above, is it simply a case of copying or moving one or more of these to another PostgreSQL folder?

      A virtual candle has been lit in Thanksgiving.

        Finding myself down a dark alley and at a dead end, I decided to return to my First Love and go back to the start,
        back to Genesis.

        I ran pexports and dllname again, as advised in the README,
        however this time I did it within the directory as recommended.

        This time, though it still failed, it solved the undefined symbol... issue.
        Now, however, some of the tests are failing. One appears due to a function name cAsE mIsMaTcH:

        user @ computer c:\Program Files\PostgreSQL\12\bin >pexports libpq.dll > libpq.def user @ computer c:\Program Files\PostgreSQL\12\bin >dlltool -dllname libpq.dll --def libpq.def --output-lib ..\lib\libpq. +a user @ computer c:\Program Files\PostgreSQL\12\bin >cpan DBD::Pg Loading internal logger. Log::Log4perl recommended for better logging CPAN: Term::ANSIColor loaded ok (v4.06) Reading 'C:\Perl64\cpan\Metadata' Database was generated on Wed, 12 Feb 2020 06:55:27 GMT Running install for module 'DBD::Pg' CPAN: Digest::SHA loaded ok (v5.98) CPAN: Compress::Zlib loaded ok (v2.074) Checksum for C:\Perl64\cpan\sources\authors\id\T\TU\TURNSTEP\DBD-Pg-3. +10.4.tar.gz ok CPAN: Archive::Tar loaded ok (v2.26) DBD-Pg-3.10.4/ DBD-Pg-3.10.4/MANIFEST DBD-Pg-3.10.4/quote.c DBD-Pg-3.10.4/dbivport.h DBD-Pg-3.10.4/README.win32 DBD-Pg-3.10.4/Makefile.PL DBD-Pg-3.10.4/Pg.xs DBD-Pg-3.10.4/types.h DBD-Pg-3.10.4/t/ DBD-Pg-3.10.4/t/dbdpg_test_setup.pl DBD-Pg-3.10.4/t/01connect.t DBD-Pg-3.10.4/t/06bytea.t DBD-Pg-3.10.4/t/00basic.t DBD-Pg-3.10.4/t/99cleanup.t DBD-Pg-3.10.4/t/02attribs.t DBD-Pg-3.10.4/t/10_pg_error_field.t DBD-Pg-3.10.4/t/03dbmethod.t DBD-Pg-3.10.4/t/lib/ DBD-Pg-3.10.4/t/lib/App/ DBD-Pg-3.10.4/t/lib/App/Info.pm DBD-Pg-3.10.4/t/lib/App/Info/ DBD-Pg-3.10.4/t/lib/App/Info/Handler.pm DBD-Pg-3.10.4/t/lib/App/Info/Request.pm DBD-Pg-3.10.4/t/lib/App/Info/RDBMS/ DBD-Pg-3.10.4/t/lib/App/Info/RDBMS/PostgreSQL.pm DBD-Pg-3.10.4/t/lib/App/Info/RDBMS.pm DBD-Pg-3.10.4/t/lib/App/Info/Handler/ DBD-Pg-3.10.4/t/lib/App/Info/Handler/Print.pm DBD-Pg-3.10.4/t/lib/App/Info/Handler/Prompt.pm DBD-Pg-3.10.4/t/lib/App/Info/Util.pm DBD-Pg-3.10.4/t/08async.t DBD-Pg-3.10.4/t/30unicode.t DBD-Pg-3.10.4/t/04misc.t DBD-Pg-3.10.4/t/12placeholders.t DBD-Pg-3.10.4/t/01constants.t DBD-Pg-3.10.4/t/00_signature.t DBD-Pg-3.10.4/t/09arrays.t DBD-Pg-3.10.4/t/07copy.t DBD-Pg-3.10.4/t/20savepoints.t DBD-Pg-3.10.4/t/03smethod.t DBD-Pg-3.10.4/LICENSES/ DBD-Pg-3.10.4/LICENSES/artistic.txt DBD-Pg-3.10.4/LICENSES/gpl-2.0.txt DBD-Pg-3.10.4/testme.tmp.pl DBD-Pg-3.10.4/win32.mak DBD-Pg-3.10.4/dbdimp.c DBD-Pg-3.10.4/types.c DBD-Pg-3.10.4/TODO DBD-Pg-3.10.4/lib/ DBD-Pg-3.10.4/lib/Bundle/ DBD-Pg-3.10.4/lib/Bundle/DBD/ DBD-Pg-3.10.4/lib/Bundle/DBD/Pg.pm DBD-Pg-3.10.4/Pg.pm DBD-Pg-3.10.4/META.yml DBD-Pg-3.10.4/Changes DBD-Pg-3.10.4/README.dev DBD-Pg-3.10.4/README DBD-Pg-3.10.4/Pg.h DBD-Pg-3.10.4/dbdimp.h DBD-Pg-3.10.4/.perlcriticrc DBD-Pg-3.10.4/MANIFEST.SKIP DBD-Pg-3.10.4/SIGNATURE DBD-Pg-3.10.4/quote.h CPAN: YAML::XS loaded ok (v0.66) CPAN: CPAN::Meta::Requirements loaded ok (v2.140) CPAN: Parse::CPAN::Meta loaded ok (v2.150010) CPAN: CPAN::Meta loaded ok (v2.150010) CPAN: Module::CoreList loaded ok (v5.20171120) Configuring T/TU/TURNSTEP/DBD-Pg-3.10.4.tar.gz with Makefile.PL Configuring DBD::Pg 3.10.4 PostgreSQL version: 120001 (default port: 5432) POSTGRES_HOME: C:\Program Files\PostgreSQL\12 POSTGRES_INCLUDE: C:\Program Files\PostgreSQL\12\include POSTGRES_LIB: C:\Program Files\PostgreSQL\12\lib OS: MSWin32 Multiple copies of Driver.xst found in: C:/Perl64/site/lib/auto/DBI/ C +:/Perl64/lib/auto/DBI/ at Makefile.PL line 182. Checking if your kit is complete... Looks good Warning (mostly harmless): No library found for -lm Warning (mostly harmless): No library found for -lsecur32 Warning (mostly harmless): No library found for -lmoldname Warning (mostly harmless): No library found for -lkernel32 Warning (mostly harmless): No library found for -luser32 Warning (mostly harmless): No library found for -lgdi32 Warning (mostly harmless): No library found for -lwinspool Warning (mostly harmless): No library found for -lcomdlg32 Warning (mostly harmless): No library found for -ladvapi32 Warning (mostly harmless): No library found for -lshell32 Warning (mostly harmless): No library found for -lole32 Warning (mostly harmless): No library found for -loleaut32 Warning (mostly harmless): No library found for -lnetapi32 Warning (mostly harmless): No library found for -luuid Warning (mostly harmless): No library found for -lws2_32 Warning (mostly harmless): No library found for -lmpr Warning (mostly harmless): No library found for -lwinmm Warning (mostly harmless): No library found for -lversion Warning (mostly harmless): No library found for -lodbc32 Warning (mostly harmless): No library found for -lodbccp32 Warning (mostly harmless): No library found for -lcomctl32 Multiple copies of Driver.xst found in: C:/Perl64/site/lib/auto/DBI/ C +:/Perl64/lib/auto/DBI/ at Makefile.PL line 284. Using DBI 1.643 (for perl 5.026001 on MSWin32-x64-multi-thread) instal +led in C:/Perl64/site/lib/auto/DBI/ Generating a dmake-style Makefile Writing Makefile for DBD::Pg Writing MYMETA.yml and MYMETA.json TURNSTEP/DBD-Pg-3.10.4.tar.gz C:\Perl64\bin\perl.exe Makefile.PL INSTALLDIRS=site -- OK Running make for T/TU/TURNSTEP/DBD-Pg-3.10.4.tar.gz cp Pg.pm blib\lib\DBD/Pg.pm cp lib/Bundle/DBD/Pg.pm blib\lib/Bundle/DBD/Pg.pm Running Mkbootstrap for Pg () "C:\Perl64\bin\perl.exe" -MExtUtils::Command -e chmod -- 644 "Pg.bs" "C:\Perl64\bin\perl.exe" -MExtUtils::Command::MM -e cp_nonempty -- Pg. +bs blib\arch\auto\DBD\Pg\Pg.bs 644 "C:\Perl64\bin\perl.exe" -p -e "s/~DRIVER~/Pg/g; s/^do\(/dontdo\(/" C: +\Perl64\site\lib\auto\DBI\Driver.xst > Pg.xsi "C:\Perl64\bin\perl.exe" "C:\Perl64\lib\ExtUtils\xsubpp" -typemap C:\ +Perl64\lib\ExtUtils\typemap Pg.xs > Pg.xsc "C:\Perl64\bin\perl.exe" -MExtUtils::Command -e mv -- Pg.xsc Pg.c C:\Perl64\site\bin\gcc.exe -c -I"C:\Program Files\PostgreSQL\12\inclu +de" -IC:\Perl64\site\lib\auto\DBI -s -O2 -DWIN32 -DWIN64 -DCO +NSERVATIVE -DPERL_TEX TMODE_SCRIPTS -DUSE_SITECUSTOMIZE -DPERL_IMPLICIT_CONTEXT -DPERL_IMPLI +CIT_SYS -fwrapv -fno-strict-aliasing -mms-bitfields -DPGLIBVERSION=12 +0001 -DPGDEFPORT=5432 -s -O2 -DVERSION=\"3.10.4\" -DXS_VERSION=\"3.10.4\" "-IC: +\Perl64\lib\CORE" Pg.c C:\Perl64\site\bin\gcc.exe -c -I"C:\Program Files\PostgreSQL\12\inclu +de" -IC:\Perl64\site\lib\auto\DBI -s -O2 -DWIN32 -DWIN64 -DCO +NSERVATIVE -DPERL_TEX TMODE_SCRIPTS -DUSE_SITECUSTOMIZE -DPERL_IMPLICIT_CONTEXT -DPERL_IMPLI +CIT_SYS -fwrapv -fno-strict-aliasing -mms-bitfields -DPGLIBVERSION=12 +0001 -DPGDEFPORT=5432 -s -O2 -DVERSION=\"3.10.4\" -DXS_VERSION=\"3.10.4\" "-IC: +\Perl64\lib\CORE" dbdimp.c dbdimp.c: In function 'pg_st_prepare_statement': dbdimp.c:2368:44: warning: cast from pointer to integer of different s +ize [-Wpointer-to-int-cast] dbdimp.c:2383:33: warning: cast from pointer to integer of different s +ize [-Wpointer-to-int-cast] dbdimp.c: In function 'pg_st_execute': dbdimp.c:3404:52: warning: cast from pointer to integer of different s +ize [-Wpointer-to-int-cast] dbdimp.c:3419:41: warning: cast from pointer to integer of different s +ize [-Wpointer-to-int-cast] dbdimp.c:3498:52: warning: cast from pointer to integer of different s +ize [-Wpointer-to-int-cast] dbdimp.c:3515:41: warning: cast from pointer to integer of different s +ize [-Wpointer-to-int-cast] dbdimp.c:3575:52: warning: cast from pointer to integer of different s +ize [-Wpointer-to-int-cast] dbdimp.c:3592:41: warning: cast from pointer to integer of different s +ize [-Wpointer-to-int-cast] dbdimp.c: In function 'pg_st_finish': dbdimp.c:3899:42: warning: cast from pointer to integer of different s +ize [-Wpointer-to-int-cast] dbdimp.c: In function 'pg_st_destroy': dbdimp.c:4070:10: warning: cast from pointer to integer of different s +ize [-Wpointer-to-int-cast] dbdimp.c: In function 'pg_db_result': dbdimp.c:5233:52: warning: cast from pointer to integer of different s +ize [-Wpointer-to-int-cast] dbdimp.c:5247:41: warning: cast from pointer to integer of different s +ize [-Wpointer-to-int-cast] C:\Perl64\site\bin\gcc.exe -c -I"C:\Program Files\PostgreSQL\12\inclu +de" -IC:\Perl64\site\lib\auto\DBI -s -O2 -DWIN32 -DWIN64 -DCO +NSERVATIVE -DPERL_TEX TMODE_SCRIPTS -DUSE_SITECUSTOMIZE -DPERL_IMPLICIT_CONTEXT -DPERL_IMPLI +CIT_SYS -fwrapv -fno-strict-aliasing -mms-bitfields -DPGLIBVERSION=12 +0001 -DPGDEFPORT=5432 -s -O2 -DVERSION=\"3.10.4\" -DXS_VERSION=\"3.10.4\" "-IC: +\Perl64\lib\CORE" quote.c C:\Perl64\site\bin\gcc.exe -c -I"C:\Program Files\PostgreSQL\12\inclu +de" -IC:\Perl64\site\lib\auto\DBI -s -O2 -DWIN32 -DWIN64 -DCO +NSERVATIVE -DPERL_TEX TMODE_SCRIPTS -DUSE_SITECUSTOMIZE -DPERL_IMPLICIT_CONTEXT -DPERL_IMPLI +CIT_SYS -fwrapv -fno-strict-aliasing -mms-bitfields -DPGLIBVERSION=12 +0001 -DPGDEFPORT=5432 -s -O2 -DVERSION=\"3.10.4\" -DXS_VERSION=\"3.10.4\" "-IC: +\Perl64\lib\CORE" types.c "C:\Perl64\bin\perl.exe" -MExtUtils::Mksymlists \ -e "Mksymlists('NAME'=>\"DBD::Pg\", 'DLBASE' => 'Pg', 'DL_FUNCS' +=> { }, 'FUNCLIST' => [], 'IMPORTS' => { }, 'DL_VARS' => []);" C:\Perl64\site\bin\g++.exe Pg.def -o blib\arch\auto\DBD\Pg\Pg.dll -mdl +l -s -static-libgcc -static-libstdc++ -L"C:\Perl64\lib\CORE" -L"C:\Mi +nGW\x86_64-w64-mingw3 2\lib" Pg.o dbdimp.o quote.o types.o "C:\Perl64\lib\CORE\libperl526. +a" "C:\Program Files\PostgreSQL\12\lib\libpq.a" -Wl,--enable-auto-ima +ge-base "C:\Perl64\bin\perl.exe" -MExtUtils::Command -e chmod -- 755 blib\arch +\auto\DBD\Pg\Pg.dll TURNSTEP/DBD-Pg-3.10.4.tar.gz C:\Perl64\site\bin\dmake.exe -- OK CPAN: CPAN::DistnameInfo loaded ok (v0.12) Running make test for TURNSTEP/DBD-Pg-3.10.4.tar.gz "C:\Perl64\bin\perl.exe" -MExtUtils::Command::MM -e cp_nonempty -- Pg. +bs blib\arch\auto\DBD\Pg\Pg.bs 644 "C:\Perl64\bin\perl.exe" "-MExtUtils::Command::MM" "-MTest::Harness" " +-e" "undef *Test::Harness::Switches; test_harness(0, 'blib\lib', 'bli +b\arch')" t/*.t t/00_signature.t ....... skipped: Set the environment variable TEST_SI +GNATURE to enable this test t/00basic.t ............ ok t/01connect.t .......... 11/15 # # DBI Version 1.643 # DBD::Pg Version 3.10.4 # Perl Version 5.26.1 # OS MSWin32 # PostgreSQL (compiled) 120001 # PostgreSQL (target) 120001 # PostgreSQL (reported) PostgreSQL 12.1, compiled by Visual C++ +build 1914, 64-bit # Default port 5432 # DBI_DSN dbi:Pg:db="testdb" # DBI_USER postgres # Test schema dbd_pg_testschema # PGPORT 5432 # PGUSER postgres # array_nulls on # backslash_quote safe_encoding # client_encoding UTF8 # server_encoding UTF8 # standard_conforming_strings on t/01connect.t .......... ok t/01constants.t ........ ok t/02attribs.t .......... ok
        t/03dbmethod.t ......... 108/580 Issuing rollback() due to DESTROY wit +hout explicit disconnect() of DBD::Pg::db handle dbname=testdb at t/0 +3dbmethod.t line 2103 .
        t/03dbmethod.t ......... ok t/03smethod.t .......... ok
        t/04misc.t ............. 81/95 DBD::Pg::db do failed: ERROR: invalid +value for parameter "max_stack_depth": 4096 DETAIL: "max_stack_depth" must not exceed 3584kB. HINT: Increase the platform's stack depth limit via "ulimit -s" or lo +cal equivalent. at t/04misc.t line 531, <$fh> line 8. Issuing rollback() due to DESTROY without explicit disconnect() of DBD +::Pg::db handle dbname=testdb at t/04misc.t line 531, <$fh> line 8. Error removing C:\Perl64\cpan\build\DBD-Pg-3.10.4-11\dbdpg_test_gBvnuZ +tst at C:/Perl64/lib/File/Temp.pm line 762. # Looks like your test exited with 255 just after 81. t/04misc.t ............. Dubious, test returned 255 (wstat 65280, 0xff +00) Failed 14/95 subtests
        t/06bytea.t ............ ok t/07copy.t ............. ok t/08async.t ............ ok t/09arrays.t ........... ok
        t/10_pg_error_field.t .. 1/? # Failed test '(query 4) Calling pg_error_field returns expected val +ue for field pg_diag_source_file' # at t/10_pg_error_field.t line 92. # 'd:\pginstaller_12.auto\postgres.windows-x64\src\b +ackend\executor\execmain.c' # doesn't match '(?^:execMain.c)' # Failed test '(query 4) Calling pg_error_field returns expected val +ue for field PG_DIAG_SOURCE_FILE' # at t/10_pg_error_field.t line 97. # 'd:\pginstaller_12.auto\postgres.windows-x64\src\b +ackend\executor\execmain.c' # doesn't match '(?^:execMain.c)' t/10_pg_error_field.t .. 286/? # Failed test '(query 4) Calling pg_e +rror_field returns expected value for field SOURCE_FILE' # at t/10_pg_error_field.t line 102. # 'd:\pginstaller_12.auto\postgres.windows-x64\src\b +ackend\executor\execmain.c' # doesn't match '(?^:execMain.c)' # Failed test '(query 5) Calling pg_error_field returns expected val +ue for field pg_diag_source_file' # at t/10_pg_error_field.t line 92. # 'd:\pginstaller_12.auto\postgres.windows-x64\src\b +ackend\executor\execmain.c' # doesn't match '(?^:execMain.c)' # Failed test '(query 5) Calling pg_error_field returns expected val +ue for field PG_DIAG_SOURCE_FILE' # at t/10_pg_error_field.t line 97. # 'd:\pginstaller_12.auto\postgres.windows-x64\src\b +ackend\executor\execmain.c' # doesn't match '(?^:execMain.c)' t/10_pg_error_field.t .. 358/? # Failed test '(query 5) Calling pg_e +rror_field returns expected value for field SOURCE_FILE' # at t/10_pg_error_field.t line 102. # 'd:\pginstaller_12.auto\postgres.windows-x64\src\b +ackend\executor\execmain.c' # doesn't match '(?^:execMain.c)' # Looks like you failed 6 tests of 364. t/10_pg_error_field.t .. Dubious, test returned 6 (wstat 1536, 0x600) Failed 6/364 subtests
        t/12placeholders.t ..... ok t/20savepoints.t ....... ok t/30unicode.t .......... ok t/99cleanup.t .......... ok
        Test Summary Report ------------------- t/04misc.t (Wstat: 65280 Tests: 81 Failed: 0) Non-zero exit status: 255 Parse errors: Bad plan. You planned 95 tests but ran 81. t/10_pg_error_field.t (Wstat: 1536 Tests: 364 Failed: 6) Failed tests: 284-286, 356-358 Non-zero exit status: 6 Files=17, Tests=2846, 24 wallclock secs ( 0.09 usr + 0.02 sys = 0.11 + CPU) Result: FAIL Failed 2/17 test programs. 6/2846 subtests failed. dmake.exe: Error code 255, while making 'test_dynamic' TURNSTEP/DBD-Pg-3.10.4.tar.gz C:\Perl64\site\bin\dmake.exe test -- NOT OK //hint// to see the cpan-testers results for installing this module, t +ry: reports TURNSTEP/DBD-Pg-3.10.4.tar.gz
        user @ computer c:\Program Files\PostgreSQL\12\bin >

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: perlquestion [id://11112712]
Approved by beech
Front-paged by Corion
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others imbibing at the Monastery: (4)
As of 2020-02-19 23:17 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    What numbers are you going to focus on primarily in 2020?










    Results (86 votes). Check out past polls.

    Notices?