Re: pg 7.4.x - pg_restore impossibly slow

On 4/13/06, Jim C. Nasby <jnasby(at)pervasive(dot)com> wrote:
> On Thu, Apr 13, 2006 at 06:26:00PM -0700, patrick keshishian wrote:
> > $ dropdb dbname
> > $ createdb dbname
> > $ pg_restore -vsOd dbname dbname.DUMP
>
> That step is pointless, because the next pg_restore will create the
> schema for you anyway.

Yes, I noticed this with the verbose output (random
non-standard option "-v").

I was providing all information (read: exact steps taken)
which may have been relevant to my post/question, so
that, I would avoid being guilty of omitting any possibly
significant, yet random information.

Thanks for the insight,
--patrick