Do not upgrade pgAdmin 18.12 (max) / CI PG restore is not match with current PG admin pg_restore version

[ponceta]

Describe the bug
Try to restore a .backup file with pgAdmin 8.14, but fails with transaction_timeout failure :
pgadmin-org/pgadmin4#8171
Probably due to the last upgrade :
#523

To Reproduce
Exact steps to reproduce the behavior:

1. Go to a Pull request
2. Download datamodel dumps
3. Try restore .backup
4. See error

Expected behavior
Dumps are restored succesfully.

Screenshots / data
If applicable, add screenshots or data to help explain your problem.

Desktop (please complete the following information):

• TWW version
• QGIS Version
• OS

Additional context
Add any other context about the problem here.

[sjib]

Maybe due to latest pgadmin? I had to go back a version so that the restore version was fitting postgres version.

[ponceta]

Similar to pgadmin-org/pgadmin4#7114

We have to stick with pgAdmin 8.12 which includes pg_dump / restore librairies in 16.4
https://github.com/pgadmin-org/pgadmin4/blob/master/docs/en_US/release_notes_8_12.rst#bundled-postgresql-utilities

pgAdmin 8.13+ include pg_dump / pg_restore librairies in v.17
https://github.com/pgadmin-org/pgadmin4/blob/master/docs/en_US/release_notes_8_13.rst#bundled-postgresql-utilities

If you go further in versions, you could copy and define 16.4 pg_dump / pg_restore libraries with the pgAdmin preferences section pgadmin-org/pgadmin4#7114 (comment)

[Muhammad-Saad12]

I encountered the same problem while transferring the data form one DB to another. Both source and target DB were using v16 and PgAdmin was using v17. I solved this problem by downloading the PgAdmin v16 to and it solved my problem . You can download from here