search

EnterpriseDB / edb-installers

PostgreSQL installers packaged by EDB
22 stars 7 forks source link

%PATH% #123

Closed Dmole closed 1 month ago

Dmole commented 3 months ago

Describe the bug

On Windows Backup and Restore exit with no error message.

To Reproduce

Steps to reproduce the behavior:

  1. After using the installer linked from https://www.postgresql.org/download/windows/
  2. Run pgAdmin 4
  3. Create a database
  4. Attempt to Backup from or Restore to the database
  5. See it error with no message or logs

Expected behavior

Backup / Restore should just work. If they fail, pgAdmin 4 should log why.

Error message

Process failed No longs available Exit code 3221225781

Desktop (please complete the following information):

Additional context

If the shown command is pasted into cmd.exe the following error is shown:

The code execution cannot proceed because libzstd.dll was not found.

echo %errorlevel% -1073741515

Adding the PostgreSQL bin folder to the windows %PATH% fixes the issue.

sandeep-edb commented 1 month ago

@Dmole what version of the PostgreSQL installer have you installed?

Dmole commented 1 month ago

postgresql-16.3-1-windows-x64.exe

agarwal-kritika commented 1 month ago

@Dmole With postgresql-16.3-1-windows-x64.exe , pgAdmin v8.7 is bundled and this issue is not reproducible from our side.

dpage-edb commented 1 month ago

We're not going to be setting %PATH%; we learned 15+ years ago that that is generally a very bad idea which can lead to all manner of confusing and broken behaviour if (for example) there are multiple version of PostgreSQL installed.