Lists: | pgsql-admin |
---|
From: | "Dai, Tino" <tdai(at)loc(dot)gov> |
---|---|
To: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Questions about moving a restoring a dump from 8.1.11 to 8.2.16 |
Date: | 2010-03-26 01:43:02 |
Message-ID: | 1CA7FF980DA3824F9A5C31532B7A40DCC50DE3C7@LCXCLMB01.LCDS.LOC.GOV |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-admin |
Hi!
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)"
and I found this page on how to fix it:
http://www.penguinlinux.com/blog/lamp/tsearch2-with-postgresql-82-errors/
Except I don't understand the steps that author has laid out. Especially
step 3.
Could some step me through this or do anybody have a better way to upgrade to
postgres 8.2.16?
Thanks,
Tino
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 |
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
From: | "Dai, Tino" <tdai(at)loc(dot)gov> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
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 04:40:18 |
Message-ID: | 1CA7FF980DA3824F9A5C31532B7A40DCC4B87E16@LCXCLMB01.LCDS.LOC.GOV |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-admin |
Hi Tom,
> Is that really the first error you got? It looks like you've neglected
> to provide contrib/tsearch2 in the new installation.
I actually double checked that I did have the tsearch2.so in my pgsql/lib directory.
What I was doing was not running the tsearch2.sql in the share/contrib directory. Rather
I was dumping and the directly restoring into the 8.2 database.
What I did do was to import the share/contrib/tsearch2.sql into my database and then restore the dump
after that. I noticed some errors about not being able to create and modify the pg_ts_* tables
but didn't worry about that. It looked like all the tables are in and the pg_ts_* tables look good
too (compared them to the 8.1.11 pg_ts_* tables).
Thanks!
-Tino