Windows postgresql backup failing with error "Failed to load the PostgreSQL library: 126"
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
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.conffile 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.conffile.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>, wherenis the PostgreSQL library version. -
Create a symbolic link
libpq.sothat points to thelibpq.so.<n>, where<n>is the PostgreSQL library version.
-
