Re: Pb migrating database from Postgres 8.1 to 8.4

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

 



Hi Tom,

First of all, Big Thx for answering.

Otherwise, thx also for all this hints.
What about my case seems to be more related to the fact 'tsearch2' is already 'integrated' in 8.4
Whereas in 8.1, one has to have it 'imported' on purpose.
All this leads to conflicts during 'restore' of my DB cf. http://rockfloat.com/blog/?id=42

I'll keep U posted on know how things work out via help from above link

Regards,
Chanh






----- Mail original -----
De: "Tom Lane" <tgl@xxxxxxxxxxxxx>
À: "Robert Treat" <rob@xxxxxxxxxx>
Cc: "chanh tran" <chanh.tran@xxxxxxx>, pgsql-admin@xxxxxxxxxxxxxx
Envoyé: Vendredi 19 Avril 2013 18:09:40
Objet: Re:  Pb migrating database from Postgres 8.1 to 8.4

Robert Treat <rob@xxxxxxxxxx> writes:
> On Fri, Apr 19, 2013 at 10:19 AM, Tom Lane <tgl@xxxxxxxxxxxxx> wrote:
>> chanh.tran@xxxxxxx writes:
>>> I'm facing pbs trying to migrate my current database from Postgres 8.1 to 8.4.
>>> pg_restore: [archiver (db)] could not execute query: ERROR: could not find function "gtsvector_in" in file "/usr/lib64/pgsql/tsearch2.so"

>> Looks like you're missing the shared library that underlies tsearch2.
>> The other errors seem to be consequences of this one.

> It might be cleaner to try and remove the tsearch bits from your
> schema dump and get a fresh install of tsearch by itself before
> loading in your own schema.

Actually, on second look, I think this is expected behavior when trying to
update from pre-8.3 text search --- that whole conversion was none too
clean.  Note the warning in the tsearch2 module documentation about

	3. Load the dump data. There will be quite a few errors reported
	due to failure to recreate the original tsearch2 objects. These
	errors can be ignored, but this means you cannot restore the
	dump in a single transaction (eg, you cannot use pg_restore's -1
	switch).

If you weren't actually using the tsearch2 features before, you might be
best advised to uninstall tsearch2 from the old database before you
convert.  If you were, please read the documentation about text search
conversion carefully --- both
http://www.postgresql.org/docs/8.4/static/textsearch-migration.html
and the contrib/tsearch2 page.

			regards, tom lane


-- 
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