| From: | Sven Fischer <sepreh(at)gmx(dot)de> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Oliver Elphick" <olly(at)lfix(dot)co(dot)uk> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Almost all access to database hangs (fwd) |
| Date: | 2001-04-05 14:42:27 |
| Message-ID: | 01040516422705.10595@fischer |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Am Donnerstag, 5. April 2001 16:23 schrieb Tom Lane:
> Sounds like a job for REINDEX. I have not had to do this myself, but
> I think the procedure is (a) stop postmaster, (b) start a standalone
> backend with -O -P, (c) tell it to REINDEX DATABASE. Not sure about
> that, especially about the switches to start the backend with. Read
> the documentation.
Whoops, was too fast...read the documentation, but not completely *blush*
- a "reindex database etcs force" made everything work happily
again...phew.
Thanx a lot, Sven
--
Sven Fischer -- Mülheimer Str. 133, 51469 Bergisch Gladbach, Germany
Tel.: +49-(0)2202-458799 Fax.: +49-(0)89-244310437
sepreh(at)gmx(dot)de
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tony Grant | 2001-04-05 14:46:22 | Up to my neck in it |
| Previous Message | Sven Fischer | 2001-04-05 14:37:46 | Re: Almost all access to database hangs (fwd) |