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 [EMAIL PROTECTED] 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
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
