Skip site navigation (1) Skip section navigation (2)

From: George Essig <george_essig(at)yahoo(dot)com>
To: cgg007(at)yahoo(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Date: 2004-07-29 22:41:01
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
"Chris Gamache" <cgg007(at)yahoo(dot)com> wrote:

> When I reload and attempt to access the database I find this
> in the logs:
> ERROR:  cache lookup failed for function 75769893

You should be OK as long as you have the dump file.  If you haven't modifed any of the tsearch2
pg_ts_* tables,  try and load tsearch2.sql first before loading the dump file.  You will get a lot
of errors when you load the dump file.  It will try to create object that tsearch2.sql already
created. Things should work if you haven't modified any of the tsearch2 tables.

Below is some sample code. Change the names of the databases and the path to the *.sql files.

createdb ts_db_b;
psql ts_db_b < tsearch2.sql;
psql ts_db_b < ts_db_a.sql;

So what if you did modify the pg_ts_* tables? Load the dump file into a new database.  Read about
the regprocedure patch at:

Install the file regprocedure_7.4.patch.gz, then load the following into your database.

George Essig

pgsql-general by date

Next:From: Justin CliftDate: 2004-07-29 23:43:36
Subject: Re: mirroring data on different drives?
Previous:From: Jason TesserDate: 2004-07-29 21:42:56
Subject: Wal logs

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group