Reg Me Please wrote: > Il Tuesday 06 November 2007 22:13:15 hai scritto: > > Split it in half, with the appropriate sql on each end so the data > > still works, and see which half causes a problem. Keep splitting the > > one that causes a problem in half until you have a small one with the > > problem still. > > > > I'm guessing the problem will become obvious then. > > That's the "branch and bound". Editing 29M+ lines file takes some time. > But this is the way I'm going to go right now. Huh, why not just use pgloader? -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
