Received: from MAIL01.stbernard.com (mail01.stbernard.com [64.154.93.162]) by postgresql.org (Postfix) with ESMTP id AA9BF4758FF; Mon, 15 Jul 2002 19:39:21 -0400 (EDT) Received: by MAIL01.stbernard.com with Internet Mail Service (5.5.2653.19) id <3XM9MNR8>; Mon, 15 Jul 2002 16:39:24 -0700 Message-ID: <7C760DAA511DC74B99E7D22189F786F101BF2128@MAIL01.stbernard.com> From: Jie Liang To: 'Bruce Momjian' , Jie Liang Cc: "'admin@postgresql.org'" , "'pgsql-sql@postgresql.org'" Subject: pg_restore --flag Date: Mon, 15 Jul 2002 16:39:23 -0700 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2653.19) Content-Type: text/plain; charset="iso-8859-1" X-Archive-Number: 200207/229 X-Sequence-Number: 8607 I tried, I got same error msg. I even run as user postgres or myself, same same. My OS=FreeBSD4.3 DB=PostgreSQL7.2 Jie Liang -----Original Message----- From: Bruce Momjian [mailto:pgman@candle.pha.pa.us] Sent: Monday, July 15, 2002 4:25 PM To: Jie Liang Cc: 'Jan Wieck'; 'admin@postgresql.org'; 'pgsql-sql@postgresql.org' Subject: Re: pg_restore cannot restore index Jie Liang wrote: > su postgres -c "/usr/local/pgsql/bin/pg_restore --table=mytable > --dbname=mydb mydumpfile" > error msg > pg_restore: [archiver] could not open input file: No such file or directory > > I run it on 7.2.0 OK, my guess is that the 'su' is moving you to another directory. Try specifying the full path of the file, e.g. /var/tmp/mydumpfile. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026