Re: pg_dump --compress error - Mailing list pgsql-general

From Alban Hertroys
Subject Re: pg_dump --compress error
Date
Msg-id 9CF017DF-D81D-4274-A8EE-F5A48F0DDC1E@solfertje.student.utwente.nl
Whole thread Raw
In response to pg_dump --compress error  (yasin malli <yasinmalli@gmail.com>)
List pgsql-general
On 31 Aug 2010, at 6:44, yasin malli wrote:

> Hi everyone.
>
> I try this command ' pg_dump --compress=5 DBNAME > ***.sql ' and ' psql -f ***.sql -d DBNAME '
> but I take some error because of compression. how can restore compressed dump file without taking any error ?

By using pg_restore instead of psql.

Alban Hertroys

--
If you can't see the forest for the trees,
cut the trees and you'll see there is no forest.


!DSPAM:737,4c7c9a6510401193214009!



pgsql-general by date:

Previous
From: yasin malli
Date:
Subject: pg_dump --compress error
Next
From: Alban Hertroys
Date:
Subject: Re: pg_dump --compress error