Julie Nishimura <juliezain(at)hotmail(dot)com> writes:
> Thank you guys. I've dumped the schema and was able to load it properly this time. There were some missing text search dictionaries, fts templates and functions. I was able to recreate it. Now is my question - do I need to reload the data?
The base textual data should be fine, but if you've got derived
tsvector columns or indexes, you might need to recompute those.
regards, tom lane