BUG #15406: Restoring compressed backup across OS error

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: fotioss(at)gmail(dot)com
Subject: BUG #15406: Restoring compressed backup across OS error
Date: 2018-09-27 00:22:27
Message-ID: 15406-4ef0eaa0fefc6dc9@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2018-09-27 01:46:17 Re: BUG #15406: Restoring compressed backup across OS error
Previous Message Tom Lane 2018-09-26 23:52:04 Re: BUG #15238: Sequence owner not updated when owning table is foreign