pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedREINDEX from shell
2+ messages / 2 participants
[nested] [flat]
* REINDEX from shell
@ 2005-04-21 20:09 FBaron@co.belcorp.biz
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:19 Philip Hallstrom <postgresql@philip.pjkh.com>
parent: FBaron@co.belcorp.biz
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