Definitely run some tests on the hardware, like memtest86, and some
drive tests for bad blocks.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hello Pavel,
Thanks for the info, this is very great help.
Regard
Louis
- Original Message
From: Pavel Stehule <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Cc: Postgres
Sent: Thursday, May 15, 2008 4:43:36 AM
Subject: Re: [GENERAL] postgres crash when select a record
Hello
200
> Louis
>
> - Original Message
> From: Pavel Stehule <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Cc: Postgres
> Sent: Wednesday, May 14, 2008 6:13:05 PM
> Subject: Re: [GENERAL] postgres crash when select a record
>
> Hello
>
> Delete this broken
ED]
Cc: Postgres
Sent: Wednesday, May 14, 2008 6:13:05 PM
Subject: Re: [GENERAL] postgres crash when select a record
Hello
Delete this broken row
Regards
Pavel Stehule
2008/5/14 <[EMAIL PROTECTED]>:
> Hello,
>
> I wish some could help me on this.
>
> I got a table which has
, May 14, 2008 6:07:23 PM
Subject: Re: [GENERAL] postgres crash when select a record
Looks loke you tried to run your query whilst postgres was recovering from an
improper shutdown, try once again when the last thing in the log is
LOG: database system is ready
- Original Message
No, I didn't run the query when the DB is in recovering.
I did that after database system is ready
- Original Message
From: Glyn Astill <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]; Postgres
Sent: Wednesday, May 14, 2008 6:07:23 PM
Subject: Re: [GENERAL] postgres crash wh
Hello
Delete this broken row
Regards
Pavel Stehule
2008/5/14 <[EMAIL PROTECTED]>:
> Hello,
>
> I wish some could help me on this.
>
> I got a table which has 100500 records, when I try to query this particular
> record
>
> select * from cs_sr_mthly_rtn where mthly_rtn_id = 61609;
> Postgres cra
Looks loke you tried to run your query whilst postgres was recovering from an
improper shutdown, try once again when the last thing in the log is
LOG: database system is ready
- Original Message
From: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
To: Postgres
Sent: Wednesday, 14 May, 2008
