pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedQuestions about moving a restoring a dump from 8.1.11 to 8.2.16
3+ messages / 2 participants
[nested] [flat]
* Questions about moving a restoring a dump from 8.1.11 to 8.2.16
@ 2010-03-26 01:43 Dai, Tino <tdai@loc.gov>
2010-03-26 02:19 ` Re: Questions about moving a restoring a dump from 8.1.11 to 8.2.16 Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 3+ messages in thread
From: Dai, Tino @ 2010-03-26 01:43 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Questions about moving a restoring a dump from 8.1.11 to 8.2.16
2010-03-26 01:43 Questions about moving a restoring a dump from 8.1.11 to 8.2.16 Dai, Tino <tdai@loc.gov>
@ 2010-03-26 02:19 ` Tom Lane <tgl@sss.pgh.pa.us>
2010-03-26 04:40 ` Re: Questions about moving a restoring a dump from 8.1.11 to 8.2.16 Dai, Tino <tdai@loc.gov>
0 siblings, 1 reply; 3+ messages in thread
From: Tom Lane @ 2010-03-26 02:19 UTC (permalink / raw)
To: Dai, Tino <tdai@loc.gov>; +Cc: pgsql-admin
"Dai, Tino" <tdai@loc.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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Questions about moving a restoring a dump from 8.1.11 to 8.2.16
2010-03-26 01:43 Questions about moving a restoring a dump from 8.1.11 to 8.2.16 Dai, Tino <tdai@loc.gov>
2010-03-26 02:19 ` Re: Questions about moving a restoring a dump from 8.1.11 to 8.2.16 Tom Lane <tgl@sss.pgh.pa.us>
@ 2010-03-26 04:40 ` Dai, Tino <tdai@loc.gov>
0 siblings, 0 replies; 3+ messages in thread
From: Dai, Tino @ 2010-03-26 04:40 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: 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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2010-03-26 04:40 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-03-26 01:43 Questions about moving a restoring a dump from 8.1.11 to 8.2.16 Dai, Tino <tdai@loc.gov>
2010-03-26 02:19 ` Tom Lane <tgl@sss.pgh.pa.us>
2010-03-26 04:40 ` Dai, Tino <tdai@loc.gov>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox