• The new Python extension is now available. It allows customers to deploy and manage WSGI-based Python applications on their websites directly from Plesk.
  • The Plesk Mobile apps for iOS and Android and the Plesk Mobile Center extension have been deprecated, and are no longer available for new installations. In Plesk Obsidian 18.0.84, the Plesk Mobile Center extension will be removed from servers during the upgrade, and the Plesk Mobile apps will lose their server management features.
  • The Social Login extension has been deprecated and will be removed in Plesk Obsidian 18.0.84. After that, it will no longer be possible to log in to Plesk with a Google, Facebook, GitHub account, or with a passkey. Plesk usernames and passwords, as well as logging in with a WebPros Account, are not affected.

Resolved PostgreSQL 17 pg_dump Error on Windows Server 2022 with Plesk

shadowscript

New Pleskian
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!
 
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.
 
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.

1742149549697.png
1742149556941.png
 
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
 
Back
Top