| From: | The Hermit Hacker <scrappy(at)hub(dot)org> |
|---|---|
| To: | Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | RE: pg_group_name_index corrupt? |
| Date: | 2000-05-05 00:38:12 |
| Message-ID: | Pine.BSF.4.21.0005042137400.56194-100000@thelab.hub.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Fri, 5 May 2000, Hiroshi Inoue wrote:
> > It says to 'recreate the index', but if I try to, it tells me its a system
> > table (of course) ... is there a way of fixing this without having to do
> > a dump/reload?
> >
>
> Run "reindex table pg_group force;" under standalone postmaster
> with options -O and -P. You must shutdown postmaster first.
Okay, just looked at the postgres man page, and found the -O option, but
no -P ... this is in the users-lounge/7.0/docs directory ...
Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: scrappy(at)hub(dot)org secondary: scrappy(at){freebsd|postgresql}.org
| From | Date | Subject | |
|---|---|---|---|
| Next Message | The Hermit Hacker | 2000-05-05 00:54:10 | RE: pg_group_name_index corrupt? |
| Previous Message | The Hermit Hacker | 2000-05-05 00:21:09 | Re: Why Not MySQL? |