pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
archive is compressed - any data will not be available
3+ messages / 2 participants
[nested] [flat]

* archive is compressed - any data will not be available
@ 2004-12-17 10:19  Iain <iain@mst.co.jp>
  0 siblings, 1 reply; 3+ messages in thread

From: Iain @ 2004-12-17 10:19 UTC (permalink / raw)
  To: pgsql-admin

Hi All,

I'm hoping that soemone can explain this error message to me and give me an
idea of how to proceed.

I was given a set of 3 dump files (in a tar.gz archive) generated by a 7.1
DB that I'm trying to import into another 7.1 DB. 2 of the files (the
smaller ones) restore no problems, but one gives the above mentioned
message. As far as I know all 3 dumps were supposed to have been performed
using the same options (this might not be the case, but I can't tell for
now).

Following are a couple examples of the output:

[postgres@mst0001 1210]$ pg_restore --list orig_main.dump > orig.list
Archiver: WARNING - archive is compressed - any data will not be available
[postgres@mst0001 1210]$ pg_restore  orig_main.dump > orig.dump
Archiver: WARNING - archive is compressed - any data will not be available

Archiver: ******** WARNING ********
        Data restoration may fail since any defined triggers
        can not be disabled (no superuser username specified).
        This is only a problem for restoration into a database
        with triggers already defined.

Archiver: Unable to restore data from a compressed archive

The list is generated fine, and restore proceeds until the first data load
before failing.

pg_restore --help doesn't give me any clues as to other options that I 
should try.

Any suggestions?

Thanks
Iain




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: archive is compressed - any data will not be available
@ 2004-12-17 16:57  Tom Lane <tgl@sss.pgh.pa.us>
  parent: Iain <iain@mst.co.jp>
  0 siblings, 1 reply; 3+ messages in thread

From: Tom Lane @ 2004-12-17 16:57 UTC (permalink / raw)
  To: Iain <iain@mst.co.jp>; +Cc: pgsql-admin

"Iain" <iain@mst.co.jp> writes:
> I was given a set of 3 dump files (in a tar.gz archive) generated by a 7.1
> DB that I'm trying to import into another 7.1 DB. 2 of the files (the
> smaller ones) restore no problems, but one gives the above mentioned
> message.

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



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: archive is compressed - any data will not be available
@ 2004-12-20 10:17  Iain <iain@mst.co.jp>
  parent: Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 3+ messages in thread

From: Iain @ 2004-12-20 10:17 UTC (permalink / raw)
  To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: 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 




^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2004-12-20 10:17 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-12-17 10:19 archive is compressed - any data will not be available Iain <iain@mst.co.jp>
2004-12-17 16:57 ` Tom Lane <tgl@sss.pgh.pa.us>
2004-12-20 10:17   ` Iain <iain@mst.co.jp>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox