Re: Problem with restoring dump (may be tsearch-related)

Hi!

I'll find out later on - this requires editing files of 180MB/750MB.
That may take a while... I'd be quite happy to find a quicker,
preferrably automatable solution.

Regards,

	Markus

> -----Ursprüngliche Nachricht-----
> Von: Oleg Bartunov [mailto:oleg@sai.msu.su]
> Gesendet: Freitag, 6. September 2002 13:42
> An: Markus Wollny
> Cc: Tom Lane; pgsql-general@postgresql.org
> Betreff: Re: AW: [GENERAL] Problem with restoring dump (may be
> tsearch-related)
> 
> 
> It's well known problem with dump - is't solved in 7.3 ?
> btw, did editing of dump file help ?
> 
> 	Oleg
> On Fri, 6 Sep 2002, Markus Wollny wrote:
> 
> > Hi!
> >
> > No, I didn't - the DB is quite large, so it's crucial that 
> dump has got
> > acceptable speed - which it hasn't got when using 
> --inserts; as I found
> > out it seems to be a matter of sequence of the created 
> objects in the
> > dump, anyway, so that wouldn't have helped, I think. As far as I can
> > see, dump always writes the table-definitions _before_ the
> > customs-datatype-definitions. Which is causing trouble, because the
> > statements for creating tables that use custom datatypes like txtidx
> > thus result in an error but not in a table. So when the 
> COPY-statement
> > follows, which should fill the table, it finds nothing to 
> fill  - and
> > that causes all these errors.
> >
> > Regards,
> >
> > 	Markus
> >
> > > -----Ursprungliche Nachricht-----
> > > Von: Oleg Bartunov [mailto:oleg@sai.msu.su]
> > > Gesendet: Donnerstag, 5. September 2002 20:02
> > > An: Markus Wollny
> > > Cc: Tom Lane; pgsql-general@postgresql.org
> > > Betreff: Re: [GENERAL] Problem with restoring dump (may be
> > > tsearch-related)
> > >
> > >
> > > Markus, did you try dump with --inserts option ?
> > >
> >
> 
> 	Regards,
> 		Oleg
> _____________________________________________________________
> Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
> Sternberg Astronomical Institute, Moscow University (Russia)
> Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
> phone: +007(095)939-16-83, +007(095)939-23-83
> 
>