Re: Problem with restoring dump (may be tsearch-related) - Mailing list pgsql-general
From | Oleg Bartunov |
---|---|
Subject | Re: Problem with restoring dump (may be tsearch-related) |
Date | |
Msg-id | Pine.GSO.4.44.0209051809530.3967-100000@ra.sai.msu.su Whole thread Raw |
In response to | Problem with restoring dump (may be tsearch-related) ("Markus Wollny" <Markus.Wollny@computec.de>) |
List | pgsql-general |
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
pgsql-general by date: