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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
