"Iain" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster