Re: Cache lookup failure for pg_restore? - Mailing list pgsql-general

From Oleg Bartunov
Subject Re: Cache lookup failure for pg_restore?
Date
Msg-id Pine.GSO.4.58.0405091715560.9525@ra.sai.msu.su
Whole thread Raw
In response to Re: Cache lookup failure for pg_restore?  (Denis Braekhus <denis@startsiden.no>)
List pgsql-general
Recently, we discover how to avoid problem with OIDs backup/restore
in tsearch2. Check http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/ for
a little patch (regprocedure_7.4.patch.gz). It won't work on existed tsearch2
installation, though, but will help in future.

    Oleg
On Sun, 9 May 2004, Denis Braekhus wrote:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Razvan Surdulescu wrote:
>
> | After I restore a Postgres database (using pg_restore), I get the
> | following error message when I try to run a simple UPDATE query:
> |
> | ERROR:  cache lookup failed for function 70529
>
> Hi Razvan,
>
> Just to add to what Tom has already said, this is most certainly because
> of your tsearch/gist usage. Check the Tsearch2 site [1] for a lot of
> interesting documentation on Tsearch2.
> For a quite nice howto on backups and restores of databases with
> Tsearch2 see the Tsearch2 Intro document [2]
>
> There is actually now a patch [3] to tsearch (only for 7.4 though) which
> is supposed to improve dumping and reloading of tsearch2 databases.
>
> [1] http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/
> [2]
> http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/docs/tsearch-V2-intro.html
> [3]
> http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/regprocedure_7.4.patch.gz
>
> Best Regards
> - --
> Denis
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.2.2-nr2 (Windows XP)
>
> iD8DBQFAniUSvsCA6eRGOOARAtJpAKCt4Wcrea3bIxu8fXw/5ZNFACdohwCfZPDf
> UuCk1dXLx8SCS4/qMniC2z4=
> =871m
> -----END PGP SIGNATURE-----
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
>

    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:

Previous
From: Denis Braekhus
Date:
Subject: Re: Cache lookup failure for pg_restore?
Next
From: Tom Lane
Date:
Subject: Re: Slow network retrieves