Thread: BUG #15406: Restoring compressed backup across OS error

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

=?utf-8?q?PG_Bug_reporting_form?= <noreply@postgresql.org> writes:
> Restoring a compressed dump from Redhat to CentOS produces an error saying
> that compression is not installed,

You should take that up with whoever built the CentOS Postgres package
that you're using.

            regards, tom lane