Webboard: mnogosearch-3.3.10 vs. postgres-9.0
| Newsgroups | gmane.comp.web.mnogosearch.general |
|---|---|
| Message-ID | <[email protected]> |
Author: Alexander Barkov Email: [email protected] Message: > Hello! > Ad.2. I pressed CTRL+C to stop crawling earlier. > Here is my test config: <skip> > I run mnogosearch with similar config using sqlite3 as backend with success. I'm guessing, config file should be working:) > I run indexer to crawl all site but withou changes. indexer -Eblob shows that nothing is converted: > [...] > Converting intag1F > Total converted: 0 records, 0 bytes > I just tried with your .conf file, with PostgreSQL-8.4.6. The database I use is reported by \l as using UTF8 Encoding. After short crawling it finished. "indexer -S" output is: Status Expired Total ----------------------------- 200 0 73 OK 301 0 27 Moved Permanently 302 0 27 Moved Temporarily ----------------------------- Total 0 127 The tail of "indexer -Eblob" output is: indexer[22124]: Total converted: 22896 records, 111643 bytes indexer[22124]: Converting url data indexer[22124]: Switching to new blob table. indexer[22124]: Converting to blob finished 1.11 > Query: select state,count(state) from bdicti group by state; returns values: 2 73 . It looks that data are converted but table 'bdict' is almost empty. In postgresql log i can't see any error, all queries are correct. Is it possible to turn on debug in indexer to display queries and answers from database? Maybe there is problem with encoding chars and postgres returns "invalid sequence for encoding..."? Perhaps something has changed in PostgreSQL-9. To enable debug output you need to build mnoGoSearch using: ./configure --with-pgsql --with-debug Then add DebugSQL=yes in indexer.conf. It will print all queries sent to the database backend. > Thank you for reply! > Regards, > Marcin. > Reply: <http://www.mnogosearch.org/board/message.php?id=21182>