Julie Nishimura <juliezain@xxxxxxxxxxx> 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