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