Sphinx + Mac + Postgresql = unknown type ‘pgsql’; skipping


Hey Everyone,

I’m posting this blog article due to the fact I had this problem and never found a solution online. With the help of Pat Allen and the ThinkingSphinx google group I was able to find a solution. My problem had nothing to do with not compiling using (–with-pgsql) it was far more obscure. I’m using ThinkingSphinx as a search tool in my Ruby on Rails application. This was my first Mac and when it came to indexing sphinx I would get the following error…

using config file ‘/Users/Chris/obilling/config/
development.sphinx.conf’…
indexing index ‘account_core’…
ERROR: source ‘account_core_0′: unknown type ‘pgsql’; skipping.
ERROR: index ‘account_core’: no valid sources configured; skipping.
distributed index ‘account’ can not be directly indexed; skipping.

The problem was initially created due to the fact I had tried to install sphinx using macports (sudo port install sphinx). After the macport install things weren’t working properly so I did a manual install using the following resource as a guide (). All of the articles I found said the problem was the fact I didn’t compile using ./configure –with-pgsql –without-mysql. This wasn’t the case as you can see in the resource I provided, I did compile it with pgsql support and the ./configure supported that. It all looked fine. I spent the next week working with Pat Allen and the ThinkingSphinx google group to come up with the solution.

I’m not sure if every step here is required, but I will outline the steps I followed…

First I checked to see if “searchd” was located in the opt/local/bin/ folder or in the /usr/local/bin folder.

From the terminal…

which searchd

My output showed opt/local/bin/ which indicated it was still using the macports install.

I then went about renaming these files…

cd /opt/local/bin/
sudo mv searchd searchdold
sudo mv indexer indexerold

I then uninstalled the macports install…

sudo port uninstall sphinx

and finally… I re-installed sphinx and the proper libraries manually using the following resource…
Installing Sphinx with Postgres on Leopard

Many thanks to Maxim Chernya @ Medium exposure for writing a great article on the installation process.

  1. #1 by Kevin Zink at July 9th, 2009

    Thanks a bunch for this guide. I ran into the exact same problem by installing sphinx through macports. Your guide got me up and rolling in 10 minutes ;)

  2. #2 by HEIDI21Britt at April 14th, 2010

    Don’t you understand that it is the best time to receive the credit loans, which can help you.

  3. #3 by essays at May 27th, 2010

    I was doing a little of research looking at some other term papers service. and this is the fifth link to the search essay about this topic as relayed by Google… so you are conventional that you are arrange a free service for them and embellish their traffic. So if you chastely support this then you should take the money but if your opinion has direct at all and you’re against it then you should probably erase them. But it’s still yours to decide.

  4. #4 by wars essay at June 4th, 2010

    Lots of people do not know exactly the way to finish their poetry & poets essay. Hence, at the moment they could come along your smashing knowledge connected with this good topic and just write the best college essays ever.

  5. #5 by dissertation service at June 8th, 2010

    Some hard working scholars will learn your idea connected with this post and order the thesis papers at the thesis writing service.

  6. #6 by thesis at June 9th, 2010

    I could just only imagine about such good ability in dissertation form about this good topic finishing. We normally utilize the help of the perfect dissertation writing service. In my situation it fits me perfectly.

  7. #7 by job for writers at July 10th, 2010

    Do you present the academic writing jobs service? Your facts about this good post can be good.

(will not be published)

Anti-Spam Protection by WP-SpamFree

  1. No trackbacks yet.