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 34F44D1B465
	for <pgsql-admin-postgresql.org@localhost.postgresql.org>;
	Mon, 12 Jan 2004 16:11:44 +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 90415-08
	for <pgsql-admin-postgresql.org@localhost.postgresql.org>;
	Mon, 12 Jan 2004 12:11:13 -0400 (AST)
Received: from ndl1mr1-a-fixed.sancharnet.in (ndl1mr1-a-fixed.sancharnet.in
	[61.0.0.45])
	by svr1.postgresql.org (Postfix) with ESMTP id 35EB1D1B449
	for <pgsql-admin@postgresql.org>; Mon, 12 Jan 2004 12:11:13 -0400 (AST)
Received: from conversion-daemon.ndl1mr1-a-fixed.sancharnet.in by
	ndl1mr1-a-fixed.sancharnet.in
	(iPlanet Messaging Server 5.2 HotFix 1.17 (built Jun 23 2003))
	id <0HRD00801WK2Q4@ndl1mr1-a-fixed.sancharnet.in> for
	pgsql-admin@postgresql.org; Mon, 12 Jan 2004 21:41:07 +0530 (IST)
Received: from sancharnet.in ([61.0.95.108]) by ndl1mr1-a-fixed.sancharnet.in
	(iPlanet Messaging Server 5.2 HotFix 1.17 (built Jun 23 2003))
	with ESMTPA id <0HRD00CATWYH9J@ndl1mr1-a-fixed.sancharnet.in>; Mon,
	12 Jan 2004 21:41:07 +0530 (IST)
Date: Mon, 12 Jan 2004 21:47:08 +0530
From: Sai Hertz And Control Systems <sank89@sancharnet.in>
Subject: Re: pg_dump/pg_restore
In-reply-to: <400288CC.4050005@sunet.ru>
To: Alexey Bobkov <bax@sunet.ru>
Cc: pgsql-admin@postgresql.org
Reply-To: aspire420@hotpop.com
Message-id: <4002C884.3080000@sancharnet.in>
Organization: Sai Hertz And Control Systems
MIME-version: 1.0
Content-type: text/plain; format=flowed; charset=ISO-8859-1
Content-transfer-encoding: 7BIT
X-Accept-Language: en-us, en
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.6b)
	Gecko/20031205 Thunderbird/0.4
References: <400288CC.4050005@sunet.ru>
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200401/88
X-Sequence-Number: 11951

Dear Alexey Bobkov ,

>
> 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

Use psql instead with command
psql -U username databasename -f  yourdb_file.sql
Yes you will have to edit the file a bit.
Drawbacks are :
triggers will go of on all insert and will be stumbling block in case to 
dump you may use the following command in future

pg_dump --disable-triggers -U <user_name>  -a -d -b -D -Fc -Z 9  -f 
<filername.tar.gz>  <dbname>
and to restore use
pg_restore --disable-triggers -U <user_name> -d <dbname> 
<backupfilename.tar.gz>

Regards,
Vishal Kashyap