Skip site navigation (1) Skip section navigation (2)

Re: Reindex from command line linux

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: FBaron(at)co(dot)belcorp(dot)biz
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Reindex from command line linux
Date: 2005-04-22 16:50:53
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
FBaron(at)co(dot)belcorp(dot)biz wrote:
> hi, which is the sentence to run a Database REINDEX from linux or from

You could grab src/contrib/reindexdb


psql -U <user> <dbname> -c "reindex foo"

> script or shell,etc.
> Thanks.
> 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 7: don't forget to increase your free space map settings

Your PostgreSQL solutions company - Command Prompt, Inc. 1.800.492.2240
PostgreSQL Replication, Consulting, Custom Programming, 24x7 support
Managed Services, Shared and Dedication Hosting
Co-Authors: plPHP, plPerlNG -

In response to

pgsql-admin by date

Next:From: Scott MarloweDate: 2005-04-22 17:01:45
Subject: Re: Reindex from command line linux
Previous:From: Bruno Wolff IIIDate: 2005-04-22 16:39:56
Subject: Re: Reindex from command line linux

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group