Florian G. Pflug wrote:
Is there any chance there is an easier way to backup/restore? On one
hand, its not too bad, and it'll only be once (correct?). Now that
fts is in core future backup/restores will work, right? I think it's
analogous to telling someone they are updating from tsearch2 to
tsearch3, and it might be a little more painful than just a
On the other hand I think a backup/restore will pollute the new db
with a bunch of functions and types that wont ever be used, so it's so
much cleaner to build it by hand.
Are there other fts users that might have opinions on that?
I'm not really a tsearch user (just played with it a bit once). But I
wondered if you are aware that you can prevent certain objects from
quite easiy if you use pg_dump and pg_restore together with "custom
format" (-Fc). There is some option to pg_restore that reads the dump,
and ouputs a table of contents. You can then remove some entries from
that list, and pass the modified list to pg_restore which will skip
entries that do not show up on your modified list.
Maybe we could document some regexp, awk script, or similar that strips
the tsearch stuff from such a table of contents?
regards, Florian Pflug
Ahh, I did not know that... I'll try that out and see if I can come up
with something. Thanks!
---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at