Re: pg_dump --compress error

From: Alban Hertroys <dalroi(at)solfertje(dot)student(dot)utwente(dot)nl>
To: yasin malli <yasinmalli(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_dump --compress error
Date: 2010-08-31 05:59:15
Message-ID: 9CF017DF-D81D-4274-A8EE-F5A48F0DDC1E@solfertje.student.utwente.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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!

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alban Hertroys 2010-08-31 06:38:07 Re: pg_dump --compress error
Previous Message yasin malli 2010-08-31 04:44:36 pg_dump --compress error