From: Michael Fuhr <mike@fuhr.org>
To: FBaron@co.belcorp.biz
Cc: Bruno Wolff III <bruno@wolff.to>
Cc: pgsql-admin@postgresql.org
Subject: Re: Reindex from command line linux
Date: Fri, 22 Apr 2005 11:03:45 -0600
Message-ID: <20050422170345.GA87562@winnie.fuhr.org> (raw)
In-Reply-To: <OFFEA9DF74.DD39A9C3-ON05256FEB.005A920C-05256FEB.005B41D2@belcorp.biz>
References: <20050422163956.GC4347@wolff.to>
<OFFEA9DF74.DD39A9C3-ON05256FEB.005A920C-05256FEB.005B41D2@belcorp.biz>
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/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: mike@fuhr.org, FBaron@co.belcorp.biz, bruno@wolff.to
Subject: Re: Reindex from command line linux
In-Reply-To: <20050422170345.GA87562@winnie.fuhr.org>
References: <20050422163956.GC4347@wolff.to> <OFFEA9DF74.DD39A9C3-ON05256FEB.005A920C-05256FEB.005B41D2@belcorp.biz> <20050422170345.GA87562@winnie.fuhr.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox