pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
REINDEX from shell
2+ messages / 2 participants
[nested] [flat]

* REINDEX from shell
@ 2005-04-21 20:09 FBaron@co.belcorp.biz
  2005-04-21 20:19 ` Re: REINDEX from shell Philip Hallstrom <postgresql@philip.pjkh.com>
  0 siblings, 1 reply; 2+ messages in thread

From: FBaron@co.belcorp.biz @ 2005-04-21 20:09 UTC (permalink / raw)
  To: pgsql-admin





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.




^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: REINDEX from shell
  2005-04-21 20:09 REINDEX from shell FBaron@co.belcorp.biz
@ 2005-04-21 20:19 ` Philip Hallstrom <postgresql@philip.pjkh.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Philip Hallstrom @ 2005-04-21 20:19 UTC (permalink / raw)
  To: FBaron@co.belcorp.biz; +Cc: pgsql-admin

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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2005-04-21 20:19 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-04-21 20:09 REINDEX from shell FBaron@co.belcorp.biz
2005-04-21 20:19 ` Philip Hallstrom <postgresql@philip.pjkh.com>

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