Re: Almost all access to database hangs (fwd) - Mailing list pgsql-general

From Sven Fischer
Subject Re: Almost all access to database hangs (fwd)
Date
Msg-id 01040516422705.10595@fischer
Whole thread Raw
In response to Re: Almost all access to database hangs (fwd)  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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@gmx.de

pgsql-general by date:

Previous
From: roy cabaniss
Date:
Subject: converting from php3 to php4
Next
From: nospam@nospam.nospam (Steve Jorgensen)
Date:
Subject: Re: Windows install