Windows postgresql backup failing with error "Failed to load the PostgreSQL library: 126"

[baumkuchen]

Hello, i'm trying to run a postgresql backup on a Windows 2019 server and i'm getting error message

"Failed to load the PostgreSQL library: 126"

I've correctly configured nbpgsql.conf file but keep getting that error message

Anyone can give advice solving this probelm?

---------------------------------------------------------------------------------------Logs------------------------------------------------------------

2023-09-12 13:17:46 DEBUGS: DB_PORT => 5432
2023-09-12 13:17:46 DEBUGS: DB_USER => postgres
2023-09-12 13:17:46 DEBUGS: MASTER_SERVER_NAME => centervtl
2023-09-12 13:17:46 DEBUGS: NBPGSQL_LOG_LEVEL => 4
2023-09-12 13:17:46 DEBUGS: OPERATION => backup
2023-09-12 13:17:46 DEBUGS: POLICY_NAME => testpgsql2
2023-09-12 13:17:46 DEBUGS: SCHEDULE_NAME => Default-Application-Backup
2023-09-12 13:17:46 ERR: Failed to load the PostgreSQL library: 126

[RamNagalla · Accepted solution]

was it ever worked or its new configuraiton?

can you refer below mainly where it says about creating the symbolic link?

https://www.veritas.com/support/en_US/doc/129277259-129955710-0/v129277288-129955710

The nbpgsql backup fails with the following error: "Failed to load PostgreSQL Library"

You may encounter this problem when the nbpgsql.conf file is not updated with the following: PostgreSQLlibrary file location. The PGSQL_LIB_INSTALL_PATH does not point to libpq.so.

Verify the following and then run the backup again: Add or update the PostgreSQL library file location in the nbpgsql.conf file. For more information, See The nbpgsql.conf configuration file. Ensure that the PGSQL_LIB_INSTALL_PATHis set to the correct path. It should point to libpg.so.<n>, where n is the PostgreSQL library version. Create a symbolic link libpq.so that points to the libpq.so.<n>, where <n> is the PostgreSQL library version.