Author: Alexander Barkov
Email: [email protected]
Message:
Hello,
> Hello!
> I'd like to setup search engine using postgresql-9.0 . I've a few problems with it.
> 1.
> # indexer -Ecreate
> '/usr/share/mnogosearch//pgsql/create.blob.sql' dbtype=3 dbmode=6
> SQL>'CREATE FUNCTION plpgsql_call_handler () RETURNS LANGUAGE_HANDLER AS '$libdir/plpgsql' LANGUAGE C'
> SQL>'CREATE TRUSTED LANGUAGE plpgsql HANDLER plpgsql_call_handler'
> {sqlmon.c:135} Query: CREATE TRUSTED LANGUAGE plpgsql HANDLER plpgsql_call_handler
>
> ERROR at line 3: PQexec: ERROR: language "plpgsql" already exists
>
> plpgsql is installed now by default.
You can ignore this error.
>
> 2. Bigger problem is with indexing and searching. I configured indexer.conf and search.htm (i'm running search.cgi using xinetd).
> I've started indexing page:
> ^C[18219]{01} SIGINT received. Terminating. Please wait...
Did you press Ctrl-break, or did it report SIGINT on its own?
> [18219]{01} Done (40 seconds, 51 documents, 271372 bytes, 6.63 Kbytes/sec.)
> So some documents was inserted to database. select count(*) from url; gives 130 records. Next i run indexer -Eblob:
> indexer -Eblob
> Converting to blob
> Loading URL list
> Converting intag00
<skip>
> Converting intag1F
> Total converted: 0 records, 0 bytes
> Converting url data
> Switching to new blob table.
> Converting to blob finished 0.04
>
> I'm worring about line "Total converted: 0 records, 0 bytes" , imho there shouldn't be zeroes. Search.cgi isn't working, probably because earlier problem, i'm getting:"
> An error occurred!
> Inverted word index not found. Probably you forgot to run 'indexer -Eblob'.
> "
> Can somebody give me any advice with this problem?
Make sure you have "Section" commands defined in indexer.conf.
In case of local file indexing (file:/// URL schema) make
sure you have AddType commands.
Feel free to paste your indexer.conf here,
To paste without comments and empty lines, please do:
egrep -v "^(#|$)" indexer.conf
Also, indexer might be crawling directories in the very beginning
(for example in case of the local file system), which do not
really have any words associated. Please wait when it start
crawling real documents.
Run say "indexer -n500" to crawl 100 URLs total and try
"indexer -Eblob" again.
> Thank you,
> Marcin.
Reply: <http://www.mnogosearch.org/board/message.php?id=21180>
lmpx.com only provides a reader for public news (NNTP) servers. It is not
affiliated with the servers or forums shown here and is not responsible for
the content of articles, which is written by their respective authors.