Skip site navigation (1) Skip section navigation (2)

Re: archive is compressed - any data will not be available

From: "Iain" <iain(at)mst(dot)co(dot)jp>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: archive is compressed - any data will not be available
Date: 2004-12-20 10:17:28
Message-ID: 001501c4e67d$1ed4cea0$7201a8c0@mst1x5r347kymb (view raw or flat)
Thread:
Lists: 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 


In response to

pgsql-admin by date

Next:From: Helena LourencoDate: 2004-12-20 10:52:37
Subject: unsubscribe pgsql-admin
Previous:From: 007117Date: 2004-12-20 09:57:08
Subject: Postgresql

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group