i've installed postgres on ubuntu and am trying to do a pg_dump but get the error message:

"pg_dump: [archiver] WARNING: requested compression not available in this installation -- archive will be uncompressed"

i've read that this is because i didn't install zlib along with postgres.

how can i install zlib for postgres now that postgres is already installed?


EDIT: command:

pg_dump myDb -U myUser --schema=public --format=c --compress=9 > somefile.dmp

it's because of the --format=c, but i would like to have it compressed (which custom (c) does by default).

  • Can you post the command line you're using? – James Mar 17 '10 at 9:30

It's not because of the --format=c, it's because of the --compress=9. You can use custom format without compression.

How did you install your PostgreSQL? If it was from the standard Ubuntu packages, it should have compression. If it was from source, you need to recompile with zlib available - remember to have the developer package. Normally, this would only happen if you explicitly configured it with "--disable-zlib".

  • yes compiled from source, will try re-compiling. thx. – pstanton Mar 17 '10 at 19:59

Folks, this is solved for after updated zlib-devel in centos. - Mohammed Azfar

  • 1
    The poster has an Ubuntu system, centos doesn't really apply. – sysadmin1138 May 17 '16 at 20:37

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.