yasin malli <yasinmalli(at)gmail(dot)com> writes:
> Unfortunately, only plain-old dump works correctly while restoring.
> if command contains any compress option, it won't work
--compress is normally used as an adjunct to -Fc.
I'm not real sure what you get if you specify it without that;
maybe a compressed plain-text-script dump? If so, you'd have
to pass it through gunzip and then to psql to do anything useful
with it.
regards, tom lane