Re: Questions about moving a restoring a dump from 8.1.11 to 8.2.16

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Dai, Tino" <tdai(at)loc(dot)gov>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Questions about moving a restoring a dump from 8.1.11 to 8.2.16
Date: 2010-03-26 02:19:57
Message-ID: 29967.1269569997@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Dai, Tino" <tdai(at)loc(dot)gov> writes:
> I shut down the database to upgrade from 8.1.11 to 8.2.16. We use pg_dump
> to dump and psql with the < sign to restore. But I had a problem with restoring the
> dump. I got a

> ERROR: function "snb_ru_init(internal)" does not exist
> CONTEXT: COPY pg_ts_dict, line 3, column dict_init: "snb_ru_init(internal)"

Is that really the first error you got? It looks like you've neglected
to provide contrib/tsearch2 in the new installation.

regards, tom lane

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Dai, Tino 2010-03-26 04:40:18 Re: Questions about moving a restoring a dump from 8.1.11 to 8.2.16
Previous Message Dai, Tino 2010-03-26 01:43:02 Questions about moving a restoring a dump from 8.1.11 to 8.2.16