%PATH%

[Dmole]

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):

• OS: Windows 10 (server 2022)
• pgAdmin 4 Version: 7.8

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.

• EnterpriseDB should set the %PATH% : %PATH% EnterpriseDB/edb-installers#123
• PGAdmin4 should show error messages

[khushboovashi]

Hi,

Please uninstall pgAdmin and re-install it from https://www.pgadmin.org/download/ and check.

[dpage]

That seems like a workaround to the problem at hand. We should still fix the underlying issue, as other builds of pg_dump etc. may have similar dependencies.

[Dmole]

Please uninstall pgAdmin and re-install it from https://www.pgadmin.org/download/ and check.

@khushboovashi (like postgresql.org) pgadmin.org links to enterprisedb.com for Windows, are you implying there is a fresh build with a fix?

[khushboovashi]

Please uninstall pgAdmin and re-install it from https://www.pgadmin.org/download/ and check.

@khushboovashi (like postgresql.org) pgadmin.org links to enterprisedb.com for Windows, are you implying there is a fresh build with a fix?

pgadmin.org doesn't link with enterprisedb.com installers. But as a workaround, suggesting you install the pgAdmin installer, as we do not have this issue.

[Dmole]

pgadmin.org doesn't link with enterprisedb.com

curl -s "https://www.pgadmin.org/download/pgagent-windows/" | grep -c enterprisedb.com
1

But I do see now that's the wrong large windows button ( 2x the height and contrast as the < h2 > )

Regardless

we do not have this issue.

I'll test re-installing, breaking the path, and testing if errors are shown.

[dpage]

pgadmin.org doesn't link with enterprisedb.com

curl -s "https://www.pgadmin.org/download/pgagent-windows/" | grep -c enterprisedb.com 1

That's for pgAgent, not pgAdmin.

[Dmole]

That's for pgAgent, not pgAdmin.

@dpage read the next sentence in that comment and you will see I know that, but the bad page design leads to such errors.

Please uninstall pgAdmin

@khushboovashi that looks like it's not offered as an option without also removing PostgreSQL :/ (one must click uninstall instead of modify, then uninstall all, only then is the remove pgadmin an option)

You can check only pgAdmin checkbox and uninstall it.

re-install it from https://www.pgadmin.org/download/ and check.

@khushboovashi I installed it beside the existing version ( different install location and different shortcut name) and found that while there is no lib/path issue, if I make one (by renaming zlib.dll) pgAdmin fails to report the error that is thrown from pg_dump.

As a workaround, we suggest having the community version until we find a solution to run both the pgAdmin versions (community and EDB versions) side by side.