Re: REINDEX from shell

  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--