Re: archive is compressed - any data will not be available - Mailing list pgsql-admin

From Iain
Subject Re: archive is compressed - any data will not be available
Date
Msg-id 001501c4e67d$1ed4cea0$7201a8c0@mst1x5r347kymb
Whole thread Raw
In response to archive is compressed - any data will not be available  ("Iain" <iain@mst.co.jp>)
List pgsql-admin
Hi,

Thanks for that. It seems that you were right.

We used pg_restore to create a plain text dump file on the original machine
and brought that down to the other machine which worked fine.

regards
Iain

> Apparently you are trying to load into a server compiled with different
> options --- specifically, the destination software was built without zlib
> and so has no ability to read (nor create) compressed archives.
>
> Your choices are to go back to the source DB and tell pg_dump to dump
> without compression, or to rebuild the destination DB with zlib
> available.
>
> I think, but wouldn't entirely swear to it, that zlib is only used in
> pg_dump/pg_restore, so it might be sufficient to rebuild those two
> programs and not the whole Postgresql suite.
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster


pgsql-admin by date:

Previous
From: Stefan Sobernig
Date:
Subject: unsubscribe pgsql-admin
Next
From: Helena Lourenco
Date:
Subject: unsubscribe pgsql-admin