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 B3C93538EC for ; Thu, 21 Apr 2005 17:19:41 -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 87846-10 for ; Thu, 21 Apr 2005 20:19:30 +0000 (GMT) Received: from zhonka1.zhonka.net (zhonka1.zhonka.net [66.228.195.5]) by svr1.postgresql.org (Postfix) with ESMTP id E50C65392E for ; Thu, 21 Apr 2005 17:19:28 -0300 (ADT) Received: from wolf.pjkh.com ([66.228.196.74]) by zhonka1.zhonka.net (Post.Office MTA v3.5.3 release 223 ID# 0-58414U4500L450S0V35) with ESMTP id net; Thu, 21 Apr 2005 13:19:28 -0700 Received: from localhost (localhost [127.0.0.1]) by wolf.pjkh.com (Postfix) with ESMTP id 41FEB5824; Thu, 21 Apr 2005 13:19:23 -0700 (PDT) Received: from wolf.pjkh.com ([127.0.0.1]) by localhost (wolf.pjkh.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 86313-09; Thu, 21 Apr 2005 13:19:23 -0700 (PDT) Received: by wolf.pjkh.com (Postfix, from userid 1000) id 065475823; Thu, 21 Apr 2005 13:19:22 -0700 (PDT) Received: from localhost (localhost [127.0.0.1]) by wolf.pjkh.com (Postfix) with ESMTP id F38D65822; Thu, 21 Apr 2005 13:19:22 -0700 (PDT) Date: Thu, 21 Apr 2005 13:19:22 -0700 (PDT) From: Philip Hallstrom To: FBaron@co.belcorp.biz Cc: pgsql-admin@postgresql.org Subject: Re: REINDEX from shell In-Reply-To: Message-ID: <20050421131856.V87228@wolf.pjkh.com> References: MIME-Version: 1.0 X-Virus-Scanned: by amavisd-new at pjkh.com X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.08 tagged_above=0 required=5 tests=AWL, BIZ_TLD X-Spam-Level: Content-Type: TEXT/PLAIN; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: QUOTED-PRINTABLE X-Archive-Number: 200504/307 X-Sequence-Number: 17320 This message is in MIME format. The first part should be readable text, while the remaining parts are likely unreadable without MIME-aware tools. --0-815158951-1114114762=:87228 Content-Type: TEXT/PLAIN; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: QUOTED-PRINTABLE Take a look at contrib/reindexdb... % reindexdb --help reindexdb reindexes a PostgreSQL database. Usage: reindexdb [options] [dbname] Options: -h, --host=3DHOSTNAME Database server host -p, --port=3DPORT Database server port -U, --username=3DUSERNAME Username to connect as -W, --password Prompt for password -d, --dbname=3DDBNAME Database to reindex -a, --all Reindex all databases -t, --table=3DTABLE Reindex specific table only -i, --index=3DINDEX Reindex specific index only -e, --echo Show the command(s) sent to the backend -q, --quiet Don't write any output Read the description of the SQL command REINDEX for details. On Thu, 21 Apr 2005 FBaron@co.belcorp.biz wrote: > > > > > Hi, > Which are the sentences to run a database reindex from a shell? > This is to schedule the shell in the crontab. > If you have scripts about database maintenance or you know where can I > find them, please let me know. > > > Thanks for your help. > > > Fabio Bar=F3n S. > DBA, Plataforma Tecnologica > Gerencia Corporativa de Tecnologia > Tel : 4-37-61-61 Ext. 5123 > Cel : 311 2-54-74-00 > > > Aviso de confidencialidad: > Este mensaje de correo electr=F3nico contiene informaci=F3n estrictamente > confidencial no susceptible de ser distribuida. Si usted no es el > destinatario de este mensaje, por favor no publicarlo, copiarlo o tomar > cualquier otro tipo de accion sobre esta transmision. Si recibio este > mensaje por error, por favor notifiquenoslo y eliminelo lo antes posible. > > Warning of confidentiality: > This message of electronic mail contains strictly confidential informatio= n > nonsusceptible to be distributed. If you are not the adressee of this > message, please do not publish it, copy it or take any other kind of acti= on > on this transmission. If you got this message by mistake, please notify i= t > to us and eliminate it as soon as possible. > > > ---------------------------(end of broadcast)--------------------------- > TIP 8: explain analyze is your friend > --0-815158951-1114114762=:87228--