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.

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

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…

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

How Regenerate droped table post_search_data?

Development

tgxworld (Alan Tan) January 20, 2017, 9:35am 10

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

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

How Regenerate droped table post_search_data?

Related topics