| From: | Jeff Davis <pgsql(at)j-davis(dot)com> |
|---|---|
| To: | Craig Ringer <ringerc(at)ringerc(dot)id(dot)au> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Odd corruption issue reported on dba.stackexchange.com, need advice |
| Date: | 2012-07-24 00:48:51 |
| Message-ID: | 1343090931.18608.95.camel@sussancws0025 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, 2012-07-19 at 11:35 +0800, Craig Ringer wrote:
> The short version is that the person did a bulk-load of some PostGIS
> data using the osm2pgsql data-loader tool
> ( http://wiki.openstreetmap.org/wiki/Osm2pgsql) to populate a Pg 9.1
> database. This appeared to succeed, but when the server was restarted
> it failed to come up, complaining that "WAL contains references to
> invalid pages" and "page 1493172 of relation base/16385/477861 was
> uninitialized" (for many different pages).
>
> The logs of the shutdown suggest that a backend probably crashed, but
> that shouldn't cause the WAL and heap corruption observed by the OP.
Is it possible that the machine has write cache enabled?
Regards,
Jeff Davis
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Craig Ringer | 2012-07-24 01:16:17 | Re: Odd corruption issue reported on dba.stackexchange.com, need advice |
| Previous Message | Guillaume Lelarge | 2012-07-23 20:46:54 | Re: meaning of "waiting" column in pg_stat_activity? |