Alvaro Herrera <alvherre@xxxxxxxxxxxxxxxxx> writes: > Dave Page wrote: >> That said, is zlib used by toast or do we have some other code for >> that? If it is used for that, do we record it's presence or absence in >> pg_control? > Nope, toast uses its own compression code. pg_dump/pg_restore use zlib, but I believe there's a pretty specific error message if you try to read a compressed archive with a non-zlib-enabled pg_restore. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings