| 1 | = Force reindex of a Cinnamon repository |
| 2 | * **Optional:** In some cases, the index in the file system must be deleted, typically in the path {{{/opt/cinnamon/cinnamon-data/index/content}}}. |
| 3 | * Log on to the database as user {{{postgres}}}. |
| 4 | * Execute the following SQL statements: |
| 5 | {{{ |
| 6 | insert into index_jobs select id,false,'cinnamon.ObjectSystemData',id from objects; |
| 7 | insert into index_jobs select id,false,'cinnamon.Folder',id from folders; |
| 8 | }}} |
| 9 | |
| 10 | > **NOTE:** If you want to index objects or folders only, leave out the other query. Obviously, you can restrict the inner {{{select}}} statement with a {{{where}}} clause, for example, to index only objects of a specific object type. |