manticoresearchHow to index data from PostgreSQL

source text_src {
  type = pgsql
  sql_host = localhost
  sql_user = usr
  sql_pass = pwd
  sql_db = db
  sql_query = SELECT id, name, description FROM test
}

index text_idx {
  type = plain
  source = text_src
  path = /var/lib/manticore/data/test
}ctrl + cyoutubegithub

`text_src` name of the source block	`type = pgsql` we're getting data from Postgresql
`localhost` Postgresql host	`usr` Postgresql auth username
`pwd` Postgresql auth password	`db` Postgresql database name
`sql_query` query to get data from Postgresql	`text_idx` name of the index block and our index
`/var/lib/manticore/data/test` path to store index files in

How to index data from Mysql

More of Manticoresearch

List all indexes on the server
Server config example
JSON over HTTP protocol example
How to index XML data
How to index data from Mysql
Find Manticore search version
Searching data in real time (RT) index using SQL
Using regex in search
Search query example using Mysql protocol

See more codes...

manticoresearchHow to index data from PostgreSQL

Related

More of Manticoresearch