Re: REINDEX from shell

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux