Re: pg_restore cannot restore an index

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: pg_restore cannot restore an index
Дата
Msg-id 200301161807.h0GI7Ld04361@candle.pha.pa.us
обсуждение исходный текст
Ответ на pg_restore cannot restore an index  ("Jie Liang" <jie@stbernard.com>)
Ответы Re: pg_restore cannot restore an index  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-sql
Yes, I remember this. The code in 7.3 looks OK to me.  Can you show me a
command line that fails for you?

I just tried:
$ pg_restore -I x asdfpg_restore: [archiver] could not open input file: No such file or directory

so it looks like -I is working.

---------------------------------------------------------------------------

Jie Liang wrote:
> Last July, I pointed out this problem when I use v7.2.1, I got the answer that will be resolved in v7.3, however, I
amusing v7.3.1, pg_restore.c seems have no change in this section. So it still doesn't work.
 
> 
> Jie Liang
> 
> 
> 
> Jie Liang wrote:
> > I read the pg_restore.c source code, I found:
> > #ifdef HAVE_GETOPT_LONG
> >         struct option cmdopts[] = {
> >                 {"clean", 0, NULL, 'c'},
> >                 {"create", 0, NULL, 'C'},
> >                 {"data-only", 0, NULL, 'a'},
> >                 {"dbname", 1, NULL, 'd'},
> >                 {"file", 1, NULL, 'f'},
> >                 {"format", 1, NULL, 'F'},
> >                 {"function", 1, NULL, 'P'},
> >                 {"host", 1, NULL, 'h'},
> >                 {"ignore-version", 0, NULL, 'i'},
> >                 {"index", 1, NULL, 'I'},
> > So, -i may be mapped wrong, however, -I is illegal option.
> > 
> > Thanks!
> > 
> > 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
> 

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073
 


В списке pgsql-sql по дате отправления:

Предыдущее
От: "Josh Berkus"
Дата:
Сообщение: Re: query speed joining tables
Следующее
От: Tom Lane
Дата:
Сообщение: Re: pg_restore cannot restore an index