Re: IO Timeout

From: "Qingqing Zhou" <zhouqq(at)cs(dot)toronto(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: IO Timeout
Date: 2005-03-11 09:32:05
Message-ID: d0ror5$1sbj$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general


How do you know that PG is in maintainence mode?

I am not sure what PG's maintainence mode is and not aware of any
configuration parameters that could control the IO reponse waiting time.
Postgres just issues the ordinary file system read/write command and wait
for the response.

Regards,
Qingqing

"Alex Turner" <armtuk(at)gmail(dot)com>
news:33c6269f0503101344397bf803(at)mail(dot)gmail(dot)com(dot)(dot)(dot)
> I have a question about IO timeouts:
>
> We are using the 3ware escalade 9500S series of cards, and we had a
> drive failure this morning. Apparnetly the card waits 30 seconds for
> the drive to respond, and if it doesn't, it put's the drive in a fail
> state. Postgres it seems didn't wait 30 seconds before it decided
> that the system was upset, and put the database in maintainence mode.
>
> Is there a way to increase to IO wait timeout so this doesn't happen?
>
> Alex Turner
> netEconomist
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Milen A. Radev 2005-03-11 10:06:16 Re: Too frequent warnings for wraparound failure
Previous Message thomas.revell 2005-03-11 08:46:50 Re: How to enable automatic md5 password prompting when

Browse pgsql-general by date

  From Date Subject
Next Message go 2005-03-11 10:15:50 pg_restore error
Previous Message Qingqing Zhou 2005-03-11 09:07:13 Statement cancel or transaction cancel?