Excerpts from yasin malli's message of mar ago 31 00:44:36 -0400 2010: > 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 ? You can restore this with zcat ***.sql | psql -d DBNAME (or "gunzip -c ***.sql" if you don't have zcat) -- Álvaro Herrera <alvherre@xxxxxxxxxxxxxxxxx> The PostgreSQL Company - Command Prompt, Inc. PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
