How to use Solr on Postgresql and index a table

Question

I am new to Solr with the specific need to crawl existing database table and generate results.

Any online example/tutorial so far only explains about you give documents and it gets indexed, but not any indication of how to do same on database.

Can anyone please explain steps how to achieve this ?

Links like this wiki shows everything with jdbc driver and mysql so I even doubt if Solr supports this with .NET or not. My tech boundries are in C# and Postgresql

have you tried the DIH

darthsidious
– darthsidious

2016-06-09 14:37:55 +00:00
Commented Jun 9, 2016 at 14:37 — darthsidious
– darthsidious, Commented Jun 9, 2016 at 14:37

MatsLindh · Accepted Answer · 2016-06-09 14:46:54Z

2

You have stumpled over the included support for JDBC already, but you have to use the postgres JDBC driver. The example will be identical with the MySQL one, but you'll have to use the proper URL for postgres instead and reference the JDBC driver (which will depend on which Postgres JDBC driver you use).

jdbc:postgresql://localhost/test

This is a configuration option in Solr, and isn't related to .NET or other external dependencies.

However, the other option is to write the indexing code yourself, and this can often be a good solution as it makes it easier to pre-process the content and apply certain logic before storing content in Solr. For .NET you have Solrnet, a Solr client, that'll make it easy to both query from and submit documents to Solr.

answered Jun 9, 2016 at 14:46

MatsLindh

53.5k5 gold badges70 silver badges97 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to use Solr on Postgresql and index a table

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related