Re: Unlinked files in PGDATA/base following unclean shutdown

From: Jack Orenstein <jack(dot)orenstein(at)hds(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Unlinked files in PGDATA/base following unclean shutdown
Date: 2008-08-11 16:13:00
Message-ID: 48A0650C.8000606@hds.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Tom Lane wrote:
> Jack Orenstein <jack(dot)orenstein(at)hds(dot)com> writes:

>> The question is how to check for consistency in the case of
>> large tables, which are split into multiple segments, (e.g. 123456.1,
>> 123456.2). I.e., how can I find out how many segments there should be?
>
> The kernel-defined EOF is the truth, the whole truth, and nothing but
> the truth. There is no other authority.
>
> All segments before the last one should be exactly 1GB, but the last
> one can be anything up to that. Consult the comments in md.c for
> more details. (I think 7.4 may treat some corner cases differently
> from 8.3 anyway.)
>
> regards, tom lane
>

Just to be clear, you mean 2**30 (1,073,741,824) bytes, not 10**9?

Jack

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joao Ferreira gmail 2008-08-11 16:30:04 big database with very small dump !?
Previous Message Joao Ferreira gmail 2008-08-11 14:25:21 diagnostic, admin, maintenance tool