By mistake i delete the table post_search_data in discourse data, How this table can be regenerated ? As this table depend upon the table posts, there might be a way to regenrate it, please help.

not have backup, is there not a way to populate the tsvector directly with PSQL and the raw also, using ssh ?

There is a rake tast that regenerates the index ./launcher enter app rake search:reindex I would strongly recommend restoring from a backup though if you have started mucking around with tables. Who knows what else happened.

sorry forgot to mention, i am on development enviorment not docker. what should i run in ruby ? should i run this ? but how ? what command exact command ? discourse/app/services/search_indexer.rb i am running rake search:reindex lets see thanks it saved my big time.

If you’ve nothing important in development mode, you can run the following commands to recreate the entire db rake db:drop db:create db:migrate

SIR, I am import DB in development to use it in production, if i use it, it will reset the db ???

Yes, it will reset the DB. But doing this and re-running the import may be the sanest way forward if you messed with the database…

Yea don’t run it if you have any important data that you can’t recreate in development mode.

[image] sam: rake search:reindex Thanks, it helped a lot.

How Regenerate droped table post_search_data?

Development

veer (Veer) January 18, 2017, 6:13pm 5

thank you very much sir, next time i keep a backup, before playing with tables.

Topic		Replies	Views
Repairing damaged post_search_data (unable to create database dumps and execute search reindex) Self-hosting	11	2732	February 13, 2017
How to reset discourse on dev mode? (w/o docker) Product Support	1	1340	May 19, 2020
Database Cleanup while writing a new Import Script Development	8	1538	December 10, 2018
Clear, empty, delete database for another import (development) Product Support	9	4055	April 17, 2020
How to regenerate the cooked column from the raw Product Support	1	2207	April 24, 2017

How Regenerate droped table post_search_data?

Related topics