The following bug has been logged on the website:
Bug reference: 15406
Logged by: Fotios Smyrnis
Email address: fotioss@gmail.com
PostgreSQL version: 9.6.6
Operating system: CentOS
Description:
Restoring a compressed dump from Redhat to CentOS produces an error saying
that compression is not installed, I am able to backup with compression and
restore on the same OS
Restoring from v9.2 to v9.6
File details of the dump are the same
Tested on an new empty database and the result is the same
- dump compressed on v9.2 Redhat - OK
- restore Redhat dump on v9.6 on Redhat server - OK
- restore Redhat dump on v9.6 on CentOS server - FAIL
- dump compressed on v9.6 on CentOS - OK
- restore CentOS on v9.6 on CentOS server - OK
Regards
Fotios