Resolved PostgreSQL 17 pg_dump Error on Windows Server 2022 with Plesk

[shadowscript]

Server operating system version

Windows Server 2022

Plesk version and microupdate number

18.0.68

Hello,


I installed Plesk on Windows Server 2022 and separately installed PostgreSQL 17. I added PostgreSQL as a database server through Tools & Settings in Plesk and scheduled the backup system. However, I am encountering a pg_dump error during the backup process.


I have already added the PostgreSQL 17 bin directory to the Windows PATH variable, and I can access pg_dump and check its version via the command line without any issues.


Below is the log error generated after the Plesk backup attempt:

Warning: Database "admin_denemedb"
Unable to make database dump. Error: Cannot run PostgreSQL client tools; make sure that they are installed: https://support.plesk.com/hc/en-us/articles/18498840918039. Unable to exec pg_dump.exe: proc_open(): CreateProcess failed, error code: 2


I would appreciate any guidance on how to resolve this issue.


Thanks in advance!

 

[scsa20]

you restarted the plesk services after adding the path in the PATH variable?

 

[shadowscript]

you restarted the plesk services after adding the path in the PATH variable?

I restarted the entire Windows Server.

I added the following path to the PATH variable:

C:\Program Files\PostgreSQL\17\bin

When I run psql --version in CMD, it works.

When I run pg_dump, it also works.

 

[scsa20]

Alright I was able to test it and it worked just fine. Make sure you set the path under the System PATH and not the User PATH since they are 2 different variables.

 

[shadowscript]

Thank you very much, you solved my problem.

I was adding the wrong path to the wrong place.
C:\Program Files\PostgreSQL\17\bin

The correct path for global variables is:
C:\Program Files\PostgreSQL\17\pgAdmin\runtime