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 Jie Liang -----Original Message----- From: Bruce Momjian [mailto:[EMAIL PROTECTED]] Sent: Monday, July 15, 2002 3:24 PM To: Jie Liang Cc: 'Jan Wieck'; '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]' Subject: Re: pg_restore cannot restore index I just ran some tests in 7.2.1 and 7.3 and both worked fine. Can I see the exact error it generates? --------------------------------------------------------------------------- Jie Liang wrote: > Same problem, did you test: > pg_restore --index=aa --dbname=test /bjm/x > ?????? > I didn't make it work, I may miss someting. > > Thanks! > > > Jie Liang > > > > -----Original Message----- > From: Bruce Momjian [mailto:[EMAIL PROTECTED]] > Sent: Saturday, July 13, 2002 7:51 AM > To: Jie Liang > Cc: 'Jan Wieck'; '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]' > Subject: Re: pg_restore cannot restore index > > > Jie Liang wrote: > > On this point, I'd like to ask: > > 1. where I can download this new version? > > 2. does > > pg_restore --index=aa --dbname=test /bjm/x > > works also??? > > OK, the attached patch should allow -I to work in 7.2.X. This will all > be fixed in 7.3. > > > Because > > pg_restore --table=mytable --dbname=mydb mydumpfile > > doesn't work! > > Is this a different problem? --table doesn't work either? > > -- > Bruce Momjian | http://candle.pha.pa.us > [EMAIL PROTECTED] | (610) 853-3000 > + If your life is a hard drive, | 830 Blythe Avenue > + Christ can be your backup. | Drexel Hill, Pennsylvania 19026 > -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
