Re: Problem with restoring dump (may be tsearch-related) - Mailing list pgsql-general

Hi!

Okay, I've been successful with the following strategy:

1. Compile&install postgresql
2. initdb
3. compile&install tsearch
4. CREATE DATABASE template2 WITH TEMPLATE = template0;
This is because template1 cannot be used as template for new databases
during restore, so another template is needed.
5. ./psql -d template2 < tsearch.sql
Now I've added the customs bits to the new template
6. perl perl -pi -e "s/template0/template2/g;" alldb1.sql
This just replaces the standard template in the dump with the new one
7. ./psql -d template1 -f alldb1.sql
I'm happy :)

Or should I fear any drawbacks of this method? The only kind of
error-messages I got during restore where those "function ... already
exists with same argument types", type named ... already exists" and
"OperatorDef: operator "##" already defined" - and I think I can safely
ignore them :)

Regards,

    Markus

> -----Ursprüngliche Nachricht-----
> Von: Markus Wollny
> Gesendet: Freitag, 6. September 2002 13:02
> An: 'Oleg Bartunov'
> Cc: Tom Lane; pgsql-general@postgresql.org
> Betreff: AW: AW: [GENERAL] 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
> >
> >
>