[OPEN-ILS-DEV] pg-loader.pl question D'oh... again...

[Dan Scott]

On 30/05/07, Mike Rylander <mrylander at gmail.com> wrote:
> On 5/30/07, Don Hamilton <dhamilton at wlu.ca> wrote:
> >
> >
> > I did it again... impatience is NOT a vurtue... I had canceled pg-loader
> > twice, when nothing appeared to be happening... I let it run all the way
> > through while typing my last 'help' email... and when it gets to the end of
> > working through all 500,000 lines of ingest, THEN it starts writing...
> >
>
> :)
>
> The reason that it waits till the end like that is so that it can
> order the output properly (all those -or options) to avoid missing
> foreign keys.
>
> --miker
>
>
> > I will not question a program 'not working' until I see it stop, or produce
> > error messages, or until the output is crap...
> > I will not question a program 'not working' until I see it stop, or produce
> > error messages, or until the output is crap...
> > I will not question a program 'not working' until I see it stop, or produce
> > error messages, or until the output is crap...
> > I will not question a program 'not working' until I see it stop, or produce
> > error messages, or until the output is crap...
> > .
> > .
> > .
> >
> >
> >
> >
> >
> > Next in a series of mind-numbing "what do I do next" questions...
> >
> > pg-loader.pl is humming away nicely on the gutenberg.ingest file I created
> > earlier, and at 300 records a second, to!
> >
> > Unfortunately, its gone through 350000 lines of the ingest file, and printed
> > zero lines of output... the command did create the file, but there's nada in
> > it.
> >
> > "what do I do next" ?
> >
> > ever thankful
> >
> > don
>
>
> --
> Mike Rylander
>

Added a note to the pg_loader.pl step in the wiki noting the need for
patience at this step, along with Mike's explanation of what is going
on behind the scenes.

Thanks Mike (and Don)!

-- 
Dan Scott
Laurentian University