Webboard: mnogosearch-3.3.10 vs. postgres-9.0

Author: Alexander Barkov
Email: [email protected]
Message:
> > I've installed postgres-8.4 mnogosearch works as i expected. I switched postgres to 9.0, mnogosearch stoped to work correctly.

> > I compared sql logs from indexex, looks simillary.

> > Would it be possible to ask you to do test with postgresql-9.0 ?

> > Thank you.

> 

> I installed PostgreSQL-9.0.2.

> 

> I can see similar behavior. Crawling seems to work fine,

> the "urlinfo" and "bdicti" tables are populated with some data,

> but "indexer -Eblob" reports 0 records in the end:

> 

> indexer[5134]: Total converted: 0 records, 0 bytes

> indexer[5134]: Converting url data

> indexer[5134]: Switching to new blob table.

> indexer[5134]: Converting to blob finished	0.24

> 

> I will check what's going on and report back soon.

> 



Ok, this is what I've found out:



In version 9, PostgreSQL has changed the default format of bytea 

values in client-server protocol from its traditional 'escape'

representation to 'hex'. mnoGoSearch does not expect hex format,

it will need some coding to make it understand hex format.

I'll try to fix this soon.





In the meanwhile, this workaround helped me:



ALTER DATABASE bar SET bytea_output TO 'escape';



Now "indexer -Eblob" works fine.



Everything else seems to work fine too:

it passes all tests in /msearch-test directory 

when running test against this PostgreSQL-9.0.2 server.



Reply: <http://www.mnogosearch.org/board/message.php?id=21187>