Windows7 64位Strawberry Perl安装DBD::Pg失败求解决方案

Hey there, let's work through this DBD::Pg installation issue you're facing. You've already tackled the initial LIBPQ.dll not found error, but now hitting undefined reference errors like PQstatus—here's how to resolve this:

First, Recap Your Setup #

• OS: Windows 7 64-bit
• Perl: Strawberry Perl 5.26.1 (double-check it's 64-bit to match your PostgreSQL!)
• PostgreSQL: 12 (64-bit)
• Current issue: Linker errors for all exported libpq symbols during cpan install DBD::Pg

Step-by-Step Solutions #

1. Ensure Proper LibPQ Symbol Export & Library Generation #

You used pexports, but let's make sure the library is generated correctly and accessible:

• Open a Strawberry Perl command prompt (to get all its tools in PATH)
• Navigate to your PostgreSQL bin directory (e.g., C:\Program Files\PostgreSQL\12\bin)
• Run these commands to generate the correct static library:

  pexports libpq.dll > libpq.def
  dlltool --dllname libpq.dll --def libpq.def --output-lib libpq.a
  

• Copy the generated libpq.a file to Strawberry Perl's lib\core directory (e.g., C:\Strawberry\perl\lib\core) or directly to PostgreSQL's lib folder—this ensures the linker can find it.

2. Explicitly Tell CPAN Where to Find PostgreSQL #

Sometimes auto-detection fails, so force the configure step to use your PostgreSQL's pgconfig:

• Set up environment variables first to point to PostgreSQL:

  SET PGDIR=C:\Program Files\PostgreSQL\12
  SET PATH=%PGDIR%\bin;%PATH%
  SET INCLUDE=%PGDIR%\include;%INCLUDE%
  SET LIB=%PGDIR%\lib;%LIB%
  

• Then launch cpan and run:

  cpan> force install DBD::Pg --configure-args="--pgconfig=%PGDIR%\bin\pgconfig.exe"
  

  The force flag skips previous failed build caches, which is helpful here.

3. Verify Bitness Match #

This is a common gotcha! Make sure:

• Your Strawberry Perl is 64-bit (check with perl -v—it should mention "x64")
• Your PostgreSQL 12 is also 64-bit
  Mismatched bitness will cause linker errors even if all paths are correct.

4. Try Precompiled Binary Packages (Easier Alternative) #

Strawberry Perl supports PPM (Perl Package Manager) which has pre-built binaries for many modules. Skip the source build entirely by:

• Launching the Strawberry Perl PPM GUI (search for "Strawberry Perl PPM" in your start menu)
• Search for DBD-Pg and install the version compatible with your Perl and PostgreSQL
• Or run this in a command prompt:

  ppm install DBD-Pg
  

Troubleshooting If You're Still Stuck #

• Check the build log (usually in C:\Users\<YourUser>\.cpan\build\DBD-Pg-*) for the exact linker command—look for -lpq or references to libpq.a to confirm it's being included.
• Ensure no other versions of PostgreSQL or libpq.dll are in your PATH (this can cause conflicts).

内容的提问来源于stack exchange，提问作者skeetastax