Re: Why are pg_restore taking that long ?

Josh Kupershmidt <schmiddy(at)gmail(dot)com> writes:
> ... Notice that pg_backup_archiver.c and
> pg_backup_tar.c use an inconsistent log level for this same message,
> which might explain where you saw the message previously.

Seems like that ought to be fixed.

> ... Or change this bit in pg_restore.c to assign a 2
> instead of a 1:
>
> case 'v': /* verbose */
> opts->verbose = 1;
> break;

"verbose" is used as a boolean, so that wouldn't actually help.

> It'd sure be nice to have these programs allow "-vvvv" style switches
> to signify cranking up the debugLevel, unless I'm missing some other
> way to do so.

Yeah. ahlog() also pays attention to a "debugLevel" value, but AFAICS
that's totally vestigial with no way to set it. It would likely be a
worthwhile activity to rationalize these things into a single
maximum-message-level value that could be ratcheted up with multiple -v
switches.

regards, tom lane