Re: sick DB - ??

From: Pete Leonard <pete(at)hero(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: sick DB - ??
Date: 2001-07-18 16:19:05
Message-ID: Pine.LNX.4.10.10107180917550.28488-100000@hero.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


As a followup - the line from top:

1641 postgres 105 0 2684K 1384K CPU1 0 8:26 99.02% 99.02%
postgres

As you can see, it's barely taking up any RAM - the process is going nuts
right off the bat..

On Wed, 18 Jul 2001, Pete Leonard wrote:

>
> Postgres 7.1.2, FreeBSD 3.4
>
> Box got sick, had to bounce it. Postgres wasn't brought down in a
> graceful fashion..
>
> restart didn't bring the DB back properly, so as the postgres user, did
> the following:
>
> /usr/local/pgsql/bin/postmaster -d5 start
>
> it dumps the initial environment variables, and then returns nothing. CPU
> is pegged at 100%. No reporting, no information as to what's happening.
>
> Solutions? It the DB corrupted badly? Where do I go from here?
>
> thanks,
>
> --pete
>
>
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-07-18 16:24:25 Re: restore single table
Previous Message Thalis A. Kalfigopoulos 2001-07-18 16:13:29 Re: restore single table