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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

-- 
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux