X-Original-To: pgsql-www-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id DD7139DCA33 for ; Sun, 12 Mar 2006 12:20:45 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 35119-09 for ; Sun, 12 Mar 2006 12:20:43 -0400 (AST) Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 7C66C9DC9E4 for ; Sun, 12 Mar 2006 12:20:43 -0400 (AST) Received: from projects.commandprompt.com (host-130.commandprompt.net [207.173.203.130]) by svr4.postgresql.org (Postfix) with ESMTP id 0D0225AF023 for ; Sun, 12 Mar 2006 16:20:42 +0000 (GMT) Received: from [192.168.1.100] (or-67-76-146-141.sta.sprint-hsd.net [67.76.146.141]) (authenticated bits=0) by projects.commandprompt.com (8.13.4/8.13.4) with ESMTP id k2CGNMVG024746 for ; Sun, 12 Mar 2006 08:23:23 -0800 From: "Joshua D. Drake" Organization: Command Prompt, Inc. To: pgsql-www@postgresql.org Subject: Re: Search machine is ready Date: Sun, 12 Mar 2006 08:23:20 -0800 User-Agent: KMail/1.9.1 References: <6BCB9D8A16AC4241919521715F4D8BCEA0F857@algol.sollentuna.se> In-Reply-To: <6BCB9D8A16AC4241919521715F4D8BCEA0F857@algol.sollentuna.se> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200603120823.20717.jd@commandprompt.com> X-Virus-Scanned: ClamAV version 0.88, clamav-milter version 0.87 on projects.commandprompt.com X-Virus-Status: Clean X-Greylist: Sender succeded SMTP AUTH authentication, not delayed by milter-greylist-1.6 (projects.commandprompt.com [192.168.2.159]); Sun, 12 Mar 2006 08:23:23 -0800 (PST) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.087 required=5 tests=[AWL=0.087] X-Spam-Score: 0.087 X-Spam-Level: X-Archive-Number: 200603/42 X-Sequence-Number: 9632 On Sunday 12 March 2006 06:42, Magnus Hagander wrote: > How about we set up a temporary "search2" or sometihng and have people > pound on it for a couple of days before we switch over? That is probably a good idea. Lets make sure the machine can handle it. (If it can't I have a bigger one we can use ;)). I will add the searchd init later today. Joshua D. Drake > > //Magnus > > > Ohh, > > > > I presume someone will need to update DNS now.... > > I will leave this side of it running until I see no more traffic. > > Shouldn't be more than a few days, a week tops. > > > > ... John > > > > > -----Original Message----- > > > From: pgsql-www-owner@postgresql.org > > > [mailto:pgsql-www-owner@postgresql.org] On Behalf Of John Hansen > > > Sent: Monday, March 13, 2006 1:26 AM > > > To: Joshua D. Drake > > > Cc: Dave Page; pgsql-www@postgresql.org > > > Subject: Re: [pgsql-www] Search machine is ready > > > > > > Yay, it's now up and running... > > > > > > Joshua, as I'm unfamilar with the ubuntu init scripts,. Could you > > > please write one to start: > > > > > > searchd -D -R /usr/local/aspseek/etc/search.d/searchd_pg.conf > > > > > > on startup, after postgresql. > > > > > > For the time being,. I will run the update script manually, > > > > until I'm > > > > > satisfied it runs glitch-free. > > > After that, it will need to be run as a cron job hourly. > > > > > > It's '/usr/local/aspseek/etc/update-archives' > > > > > > Kind Regards, > > > > > > John > > > > > > > -----Original Message----- > > > > From: Joshua D. Drake [mailto:jd@commandprompt.com] > > > > Sent: Monday, March 06, 2006 6:49 AM > > > > To: John Hansen > > > > Cc: Dave Page > > > > Subject: Re: [pgsql-www] Search machine is ready > > > > > > > > Good lord one a pain in the ass :) > > > > > > > > I got it compiled and installed ;) it is all in > > > > > > /usr/local/aspseek... > > > > > > > > > > > > > > > > > > ---------------------------(end of > > > broadcast)--------------------------- > > > TIP 9: In versions below 8.0, the planner will ignore your desire to > > > choose an index scan if your joining column's > > > > datatypes do not > > > > > match > > > > ---------------------------(end of > > broadcast)--------------------------- > > TIP 1: if posting/reading through Usenet, please send an appropriate > > subscribe-nomail command to majordomo@postgresql.org > > so that your > > message can get through to the mailing list cleanly > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Have you searched our list archives? > > http://archives.postgresql.org