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

Hi!

Source-DB is 7.2.1, target is 7.2.2, so maybe I'll try and upgrade the
source-db, too. I've never done this before without restoring a dump,
though. Are there any instructions on how to upgrade an existing
installation? Can I just unpack, run ./configure with the same settings,
make, make install and restart the postmaster? Or do I have to reinstall
from scratch? The alldb1.sql ist ~180MB in size, so I don't want to
bother anyone with this...

Regards,

    Markus

> -----Ursprungliche Nachricht-----
> Von: Oleg Bartunov [mailto:oleg@sai.msu.su]
> Gesendet: Donnerstag, 5. September 2002 17:12
> An: Markus Wollny
> Cc: pgsql-general@postgresql.org
> Betreff: Re: [GENERAL] Problem with restoring dump (may be
> tsearch-related)
>
>
> Markus,
>
> what version are you using for source and target databases ?
> There were some problem with dumping (look archives for details) and
> I think they were fixed in 7.2.2 release.
>
> small test data and sql scripts which reproduce the problem
> are welcome
>
>     regards,
>         Oleg
> On Thu, 5 Sep 2002, Markus Wollny wrote:
>
> > Hi!
> >
> > I dump all of my databases daily using pgdumpall (./pg_dumpall >
> > /var/pgbackup/alldb1.sql). Now if I try to restore the whole lot via
> > "psql -d template1 -f alldb1.sql", I get loads and loads of
> parse errors
> > like
> >
> > psql:alldb1.sql:1122826: ERROR:  parser: parse error at or
> near "uъerst"
> > psql:alldb1.sql:1122826: ERROR:  parser: parse error at or
> near "chst"
> > psql:alldb1.sql:1122826: ERROR:  parser: parse error at or
> near "mmern"
> > psql:alldb1.sql:1122827: ERROR:  parser: parse error at or
> near "ren"
> > psql:alldb1.sql:1122827: ERROR:  parser: parse error at or
> near "rfer"
> > psql:alldb1.sql:1122827: ERROR:  parser: parse error at or
> near "ndig"
> > psql:alldb1.sql:1122828: ERROR:  parser: parse error at or
> near "ren"
> > psql:alldb1.sql:1122828: ERROR:  parser: parse error at or near
> > "henvorteile"
> > psql:alldb1.sql:1122828: ERROR:  parser: parse error at or
> near "hten"
> > psql:alldb1.sql:1122829: ERROR:  parser: parse error at or
> near "ren"
> > psql:alldb1.sql:1122829: ERROR:  parser: parse error at or near
> > "berqueren"
> > psql:alldb1.sql:1122829: ERROR:  parser: parse error at or
> near "cken"
> > psql:alldb1.sql:1122830: ERROR:  parser: parse error at or
> near "ren"
> > psql:alldb1.sql:1122830: ERROR:  parser: parse error at or near "ck"
> > psql:alldb1.sql:1122831: ERROR:  parser: parse error at or
> near "ren"
> > psql:alldb1.sql:1122831: ERROR:  parser: parse error at or
> near "hrend"
> > psql:alldb1.sql:1122831: ERROR:  parser: parse error at or
> near "ude"
> > psql:alldb1.sql:1122831: ERROR:  parser: parse error at or
> near "nnen"
> > psql:alldb1.sql:1122831: ERROR:  parser: parse error at or near
> > "berzeugen"
> > ...
> >
> > I tried to restore on an freshly installed system; I compiled and
> > installed tsearch from contrib (just make install, I didn't prepare
> > template1 with it), as I use it in some tables in several
> databases on
> > the original installation. As the parse errors state
> substrings, I think
> > it might have to do something with the txtidx type not
> being present at
> > the time the inserts are being made. I can however create a
> sort of copy
> > from the original system by creating the databases on the
> target-server
> > first, then creating the tsearch-datatypes, functions and
> operators via
> > the tsearch.sql for every one of them and then finally just
> piping the
> > dump from one server to the other:
> >
> > ./pgsql/bin/pg_dump -h originalhost databasename |
> /./pgsql/bin/psql -h
> > targethost databasename
> >
> > Now this doesn't help me much in case of a real crash when
> I would have
> > to recreate the databases from the "alldb1.sql"-dump. How can I
> > accomplish this? One way might be to create the databases, install
> > tsearch for all of them, then parse the alldb1.sql and eliminate all
> > "create database"-statements and the statements that are related to
> > installation of tsearch - but I think that this would be a
> bit messy and
> > I don't know if this method would yield guaranteed success
> as I don't
> > exactly know what exactly I would need to throw out of the
> alldb1.sql.
> > Is there some better way for restoring the dumps? Or am I doing
> > something wrong (most probably :) ).
> >
> > Thanks for your help!
> >
> > Regards,
> >
> >     Markus
> >
> > ---------------------------(end of
> broadcast)---------------------------
> > TIP 3: if posting/reading through Usenet, please send an appropriate
> > subscribe-nomail command to majordomo@postgresql.org so that your
> > message can get through to the mailing list cleanly
> >
>
>     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
>
>