pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Philip Hallstrom <postgresql@philip.pjkh.com>
To: FBaron@co.belcorp.biz
Cc: pgsql-admin@postgresql.org
Subject: Re: REINDEX from shell
Date: Thu, 21 Apr 2005 13:19:22 -0700 (PDT)
Message-ID: <20050421131856.V87228@wolf.pjkh.com> (raw)
In-Reply-To: <OFCEA11D99.21933ECA-ON05256FEA.006D53C4-05256FEA.006EBCA9@belcorp.biz>
References: <OFCEA11D99.21933ECA-ON05256FEA.006D53C4-05256FEA.006EBCA9@belcorp.biz>

  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=HOSTNAME             Database server host
   -p, --port=PORT                 Database server port
   -U, --username=USERNAME         Username to connect as
   -W, --password                  Prompt for password
   -d, --dbname=DBNAME             Database to reindex
   -a, --all                       Reindex all databases
   -t, --table=TABLE               Reindex specific table only
   -i, --index=INDEX               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ón 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ónico contiene información 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 information
> 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 action
> on this transmission. If you got this message by mistake, please notify it
> to us and eliminate it as soon as possible.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
>
--0-815158951-1114114762=:87228--



view thread (2+ messages)

Message-ID: <20050421131856.V87228@wolf.pjkh.com>
Permalink:  ../20050421131856.V87228@wolf.pjkh.com/
Also on:    postgresql.org/message-id/20050421131856.V87228@wolf.pjkh.com

 · 

reply

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: postgresql@philip.pjkh.com, FBaron@co.belcorp.biz
  Subject: Re: REINDEX from shell
  In-Reply-To: <20050421131856.V87228@wolf.pjkh.com>
  References: <OFCEA11D99.21933ECA-ON05256FEA.006D53C4-05256FEA.006EBCA9@belcorp.biz> <20050421131856.V87228@wolf.pjkh.com>

* 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