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(at)co(dot)belcorp(dot)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--