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 69135D1B462 for ; Mon, 12 Jan 2004 11:42:07 +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 37535-07 for ; Mon, 12 Jan 2004 07:41:39 -0400 (AST) Received: from ns.sunet.ru (ns.sunet.ru [217.174.96.14]) by svr1.postgresql.org (Postfix) with ESMTP id 18E3CD1B49F for ; Mon, 12 Jan 2004 07:41:35 -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 i0CBfa977995 for ; Mon, 12 Jan 2004 14:41:36 +0300 (MSK) X-AntiVirus: Checked by Dr.Web (http://www.drweb.net) Message-ID: <400288CC.4050005@sunet.ru> Date: Mon, 12 Jan 2004 14:45:16 +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: pgsql-admin@postgresql.org Subject: pg_dump/pg_restore 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/84 X-Sequence-Number: 11947 PostgreSQL 7.3.2 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. Then a try to restore my data: pg_restore /path_to_database/backup/db_backup.file and get next error pg_restore: [archiver] input file does not appear to be a valid archive I think it's because in pg_dump, I not set -F c option :( How I can restore this broken file? Thanks