Re: pg_dump error... Follow up

On 8/9/05 2:38 pm, "Alvaro Herrera" <alvherre(at)alvh(dot)no-ip(dot)org> wrote:

> On Thu, Sep 08, 2005 at 10:32:41AM +0100, Adam Witney wrote:
>
>> Unfortunately the pg_filedump you requested gives an error:
>>
>> pg_filedump -R 165390 165392 134401986
>>
>> *******************************************************************
>> * PostgreSQL File/Block Formatted Dump Utility - Version 3.0
>> *
>> * File: 134401986.1
>> * Options used: -R 165390 165392
>> *
>> * Dump created on: Thu Sep 8 10:33:47 2005
>> *******************************************************************
>> Error: Premature end of file encountered.
>>
>> (there is a .1 file also for this table, do I have to stick the two together
>> or something?)
>
> No, rather tell pg_filedump to use the second segment (.1 file) and
> substract the total number of blocks in the first segment. If my math
> is right there are 131072 blocks of 8kB per 1GB segment, so to dump
> block 165390 you need to ask for block 34318 in the second segment:
>
> pg_filedump -R 34318 34320 134401986.1

Ah thanks.....

pg_filedump-3.0/pg_filedump -R 34318 34320 134401986.1

*******************************************************************
* PostgreSQL File/Block Formatted Dump Utility - Version 3.0
*
* File: 134401986.1
* Options used: -R 34318 34320
*
* Dump created on: Thu Sep 8 14:49:05 2005
*******************************************************************

Block 34318 ********************************************************
<Header> -----
Block Offset: 0x10c1c000 Offsets: Lower 36 (0x0024)
Block: Size 8192 Version 1 Upper 272 (0x0110)
LSN: logid 16 recoff 0x2b0ab37c Special 8192 (0x2000)
Items: 4 Free Space: 236
Length (including item array): 40

<Data> ------
Item 1 -- Length: 2034 Offset: 6156 (0x180c) Flags: USED
Item 2 -- Length: 2034 Offset: 4120 (0x1018) Flags: USED
Item 3 -- Length: 1811 Offset: 2308 (0x0904) Flags: USED
Item 4 -- Length: 2034 Offset: 272 (0x0110) Flags: USED

Block 34319 ********************************************************
<Header> -----
Block Offset: 0x10c1e000 Offsets: Lower 36 (0x0024)
Block: Size 8192 Version 1 Upper 48 (0x0030)
LSN: logid 16 recoff 0x2b0ad4d0 Special 8192 (0x2000)
Items: 4 Free Space: 12
Length (including item array): 40

<Data> ------
Item 1 -- Length: 2034 Offset: 6156 (0x180c) Flags: USED
Item 2 -- Length: 2034 Offset: 4120 (0x1018) Flags: USED
Item 3 -- Length: 2034 Offset: 2084 (0x0824) Flags: USED
Item 4 -- Length: 2034 Offset: 48 (0x0030) Flags: USED

Block 34320 ********************************************************
<Header> -----
Block Offset: 0x10c20000 Offsets: Lower 68 (0x0044)
Block: Size 8192 Version 1 Upper 232 (0x00e8)
LSN: logid 16 recoff 0x2d0fedcc Special 8192 (0x2000)
Items: 12 Free Space: 164
Length (including item array): 72

<Data> ------
Item 1 -- Length: 672 Offset: 7520 (0x1d60) Flags: USED
Item 2 -- Length: 668 Offset: 6852 (0x1ac4) Flags: USED
Item 3 -- Length: 656 Offset: 6196 (0x1834) Flags: USED
Item 4 -- Length: 652 Offset: 5544 (0x15a8) Flags: USED
Item 5 -- Length: 700 Offset: 4844 (0x12ec) Flags: USED
Item 6 -- Length: 652 Offset: 4192 (0x1060) Flags: USED
Item 7 -- Length: 668 Offset: 3524 (0x0dc4) Flags: USED
Item 8 -- Length: 656 Offset: 2868 (0x0b34) Flags: USED
Item 9 -- Length: 684 Offset: 2184 (0x0888) Flags: USED
Item 10 -- Length: 648 Offset: 1536 (0x0600) Flags: USED
Item 11 -- Length: 652 Offset: 884 (0x0374) Flags: USED
Item 12 -- Length: 652 Offset: 232 (0x00e8) Flags: USED

*** End of Requested Range Encountered. Last Block Read: 34320 ***

I have deleted the offending row in the table and now pg_dump does not give
the error, so it seems to be fixed.

I do have a copy of the toast.pg_toast_134401982 files 134401986 and
134401986.1 if you want me to do any further analysis for you?

Thanks again for your help

Adam

--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.