Re: pg_dump --compress error

On Tue, 2010-08-31 at 00:50 -0700, yasin malli wrote:
> I tried it and it ran without any error but my table wasn't created so
> problem is going on.
> compress level isn't important because when I controlled it gave me
> same results ( 5 or 9 )
>
> Unfortunately, only plain-old dump works correctly while restoring.
> if command contains any compress option, it won't work

Compress will not work in plaintext format for restore. You need to use
-Fc and then pg_restore.

Joshua D. Drake

--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training, Support, Custom Development, Engineering
http://twitter.com/cmdpromptinc | http://identi.ca/commandprompt