Hi Praveen When you talk about different schemas, do you mean different databases, each one for a different tenant? If so, there's no simple way to do this with Thinking Sphinx. You may need to create your own script to modify the generated configuration file, or run separate searchd instances for each tenant and change the port and/or address depending on the tenant.
Or do you mean something else when you say schema? I'm not sure. Cheers -- Pat On 20/01/2011, at 7:28 PM, praveen wrote: > Hi Everyone, > > I would like to know , how can i use thinking sphinx/sphinx to index > all the schemas in a postgres database. > > I am using Postgresql Database for my Multitenant application, where i > differentiate each tenant by Postgresql shema , which means , I > connect to the particular schema , when the user requests for the > particular tenant. > > To explain in detail, I have one rails application which will connect > to different schema in my postgresql database according to the tenant > id requested, to behave as a multitenant application. > > Since i have only one application , and i have to use the same > thinking sphinx plugin for indexing, i am not able configure to index > tables from all the schemas i have in my postgresql database. > > Please help. Thanks in advance. > > -- > You received this message because you are subscribed to the Google Groups > "Thinking Sphinx" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/thinking-sphinx?hl=en. > -- You received this message because you are subscribed to the Google Groups "Thinking Sphinx" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/thinking-sphinx?hl=en.
