X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id EE258D1D542 for ; Mon, 12 Jan 2004 14:58:42 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 78254-03 for ; Mon, 12 Jan 2004 10:58:13 -0400 (AST) Received: from ns.sunet.ru (ns.sunet.ru [217.174.96.14]) by svr1.postgresql.org (Postfix) with ESMTP id EF571D1CA0E for ; Mon, 12 Jan 2004 10:58:07 -0400 (AST) Received: from sunet.ru (55.sunet.ru [217.174.99.55]) (authenticated) by ns.sunet.ru (8.11.7/8.11.7) with ESMTP id i0CEw8988718; Mon, 12 Jan 2004 17:58:08 +0300 (MSK) X-AntiVirus: Checked by Dr.Web (http://www.drweb.net) Message-ID: <4002B6DD.6090206@sunet.ru> Date: Mon, 12 Jan 2004 18:01:49 +0300 From: Alexey Bobkov User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.5) Gecko/20031007 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Tom Lane Cc: pgsql-admin@postgresql.org Subject: Re: pg_dump/pg_restore References: <400288CC.4050005@sunet.ru> <28375.1073918818@sss.pgh.pa.us> In-Reply-To: <28375.1073918818@sss.pgh.pa.us> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200401/86 X-Sequence-Number: 11949 Tom Lane wrote: > Alexey Bobkov writes: > >>I have been dumping my database with next options: >>pg_dump -f /path_to_database/backup/db_backup.file -Z 9 database_name >>and get db_backup.file file. > > > This is giving you a plain SQL-script dump file. To restore, feed it > into psql. No :) this is giving me gzip compressed file I found solution for my problem. This is step by step instruction for me :) mv db_backup.file db_backup.file.gz gzip -g db_backup.file.gz :) thanks -- Alexey Bobkov e-Style ISP tel/fax +7 095 7969797