Re: [ADMIN] Vacuum command - Mailing list pgsql-admin

From jwieck@debis.com (Jan Wieck)
Subject Re: [ADMIN] Vacuum command
Date
Msg-id m0zoDcS-000EBQC@orion.SAPserv.Hamburg.dsh.de
Whole thread Raw
In response to Re: [ADMIN] Vacuum command  ("G. Anthony Reina" <reina@nsi.edu>)
List pgsql-admin
>
> That makes sense. Is there a way that is less drastic than dumping,
> re-initdb, and reloading the database? It would probably take a day or
> two to do this. Does anybody know if I can fix the catalog in another
> way?
>
> -Tony

    Not any more. In earlier days, there was a reindexdb command,
    which used the  bootstrap  code  to  drop  and  recreate  the
    indices  for  the  system  catalog's.  But  that  disappeared
    sometime. I think there's  no  chance,  because  dropping  of
    catalog indices isn't allowed.


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#======================================== jwieck@debis.com (Jan Wieck) #

pgsql-admin by date:

Previous
From: "G. Anthony Reina"
Date:
Subject: Re: [ADMIN] Vacuum command
Next
From: Robert Honore
Date:
Subject: Postgres on Digital UNIX 4.0D