| From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
|---|---|
| To: | yasin malli <yasinmalli(at)gmail(dot)com> |
| Cc: | Alban Hertroys <dalroi(at)solfertje(dot)student(dot)utwente(dot)nl>, "pgsql-general(at)postgresql(dot)org Postgres General" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: pg_dump --compress error |
| Date: | 2010-08-31 15:43:09 |
| Message-ID: | 1283269389.2867.9.camel@jd-desktop.unknown.charter.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2010-08-31 16:23:29 | Re: are there any documents describe the index mechanic? |
| Previous Message | Allan Kamau | 2010-08-31 14:58:47 | Finding intercept of two documents (two tsvector fields) |