Qt连接PostgreSQL时QPSQL驱动未加载的问题求助

Hey there, let's work through this QPSQL driver issue on your M1 MacBook Pro. The error you're seeing means Qt can't find the PostgreSQL driver, which usually boils down to architecture mismatches or missing driver components—let's fix this step by step.

Root Cause Breakdown #

On M1 Macs, Homebrew installs arm64-native PostgreSQL by default. If your Qt installation is the x86_64 version (like the default download from Qt's website), there's an architecture mismatch that prevents the driver from loading. Even if Qt is arm64, the PostgreSQL driver might not be installed by default.

Step 1: Verify Architecture Compatibility #

First, check if your Qt and PostgreSQL are using the same architecture:

1. Check PostgreSQL's architecture:

   file $(which psql)
   

   Look for arm64 in the output (this is the expected M1-native build).
2. Check Qt's architecture:

   file $(which qmake)
   

   If this shows x86_64, you'll need to switch to an arm64 version of Qt (download it via Qt Maintenance Tool or use Homebrew's Qt package).

Step 2: Install the Qt PostgreSQL Driver (Easy Path) #

If you're using an arm64 Qt build, the driver might just be missing. Install it via Qt Maintenance Tool:

• Open the Qt Maintenance Tool (found in your Qt install folder, e.g., ~/Qt/MaintenanceTool.app).
• Select Add or remove components.
• Expand your active Qt version, go to Additional Libraries, and check the box for PostgreSQL Driver.
• Click Apply to install the driver.

Step 3: Manually Compile the QPSQL Driver (If the Easy Path Fails) #

If the pre-built driver doesn't work, compile it yourself to match your setup:

1. Install required dependencies (if you haven't already):

   brew install postgresql qt
   

2. Navigate to Qt's PostgreSQL driver source directory (replace 6.5.3 with your Qt version):

   cd ~/Qt/6.5.3/macos/src/plugins/sqldrivers/psql
   

3. Generate the Makefile with qmake, pointing to Homebrew's PostgreSQL libraries (M1 Homebrew uses /opt/homebrew):

   qmake "INCLUDEPATH=/opt/homebrew/include" "LIBS=-L/opt/homebrew/lib -lpq" psql.pro
   

4. Compile and install the driver:

   make
   make install
   

   This will place the compiled driver in Qt's plugin directory.

Step 4: Configure Environment Variables #

Ensure Qt can find PostgreSQL's dynamic libraries by setting the DYLD_LIBRARY_PATH:

• Run this in your terminal to test temporarily:

  export DYLD_LIBRARY_PATH=/opt/homebrew/lib:$DYLD_LIBRARY_PATH
  

• To make this permanent, add the line above to your ~/.zshrc or ~/.bash_profile (depending on your shell).

Step 5: Test the Driver #

Update your test code to print available drivers and verify the connection:

#include <QSqlDatabase>
#include <QDebug>

int main() {
    qDebug() << "Available drivers:" << QSqlDatabase::drivers();
    
    QSqlDatabase db = QSqlDatabase::addDatabase("QPSQL");
    db.setHostName("localhost");
    db.setDatabaseName("postgres");
    db.setUserName("postgres");
    db.setPassword("pass");
    db.setPort(5432);

    if (db.open()) {
        qDebug() << "Database connected successfully!";
        db.close();
    } else {
        qDebug() << "Connection failed:" << db.lastError().text();
    }
    return 0;
}

If QPSQL shows up in the available drivers list and the connection succeeds, you're all set!

Also, double-check that PostgreSQL is running:

brew services start postgresql

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