PostgreSQL Bugs

Collected from the PG bugs email list.

Bug ID15406
PG Version9.6.6
OSCentOS
Opened2018-09-27 00:22:27+00
Reported byFotios Smyrnis
StatusNew

Body of first available message related to this bug follows.

The following bug has been logged on the website:

Bug reference:      15406
Logged by:          Fotios Smyrnis
Email address:      (redacted)
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

Messages

DateAuthorSubject
2018-09-27 00:22:27+00=?utf-8?q?PG_Bug_reporting_form?=BUG #15406: Restoring compressed backup across OS error
2018-09-27 01:46:17+00Tom LaneRe: BUG #15406: Restoring compressed backup across OS error