X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 8DEC253983 for ; Fri, 22 Apr 2005 14:03:52 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 97182-05 for ; Fri, 22 Apr 2005 17:03:51 +0000 (GMT) Received: from tigger.fuhr.org (tigger.fuhr.org [63.214.45.158]) by svr1.postgresql.org (Postfix) with ESMTP id 055FF53978 for ; Fri, 22 Apr 2005 14:03:50 -0300 (ADT) Received: from winnie.fuhr.org (winnie.fuhr.org [10.1.0.1]) by tigger.fuhr.org (8.13.3/8.13.3) with ESMTP id j3MH3jiK035352 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=OK); Fri, 22 Apr 2005 11:03:48 -0600 (MDT) (envelope-from mfuhr@winnie.fuhr.org) Received: from winnie.fuhr.org (localhost [127.0.0.1]) by winnie.fuhr.org (8.13.3/8.13.3) with ESMTP id j3MH3jGL091524; Fri, 22 Apr 2005 11:03:45 -0600 (MDT) (envelope-from mfuhr@winnie.fuhr.org) Received: (from mfuhr@localhost) by winnie.fuhr.org (8.13.3/8.13.3/Submit) id j3MH3j1P091523; Fri, 22 Apr 2005 11:03:45 -0600 (MDT) (envelope-from mfuhr) Date: Fri, 22 Apr 2005 11:03:45 -0600 From: Michael Fuhr To: FBaron@co.belcorp.biz Cc: Bruno Wolff III , pgsql-admin@postgresql.org Subject: Re: Reindex from command line linux Message-ID: <20050422170345.GA87562@winnie.fuhr.org> References: <20050422163956.GC4347@wolff.to> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.268 tagged_above=0 required=5 tests=AWL, BIZ_TLD X-Spam-Level: X-Archive-Number: 200504/318 X-Sequence-Number: 17331 On Fri, Apr 22, 2005 at 11:36:46AM -0500, FBaron@co.belcorp.biz wrote: > > psql -d Clibelcorpco -c "REINDEX DATABASE Clibelcorpco FORCE" > ERROR: REINDEX DATABASE: Can be executed only on the currently open > database. If the database name isn't all lowercase then you'll have to quote it. psql -d Clibelcorpco -c 'REINDEX DATABASE "Clibelcorpco"' See "Identifiers and Key Words" in the "SQL Syntax" chapter of the documentation to learn more about quoted identifiers. See also the REINDEX documentation and make sure you understand what REINDEX DATABASE does and doesn't do. Also, FORCE appears to be obsolete as of 7.4. There's also the contrib/reindexdb utility, although I haven't used it so I don't know how well it works. -- Michael Fuhr http://www.fuhr.org/~mfuhr/