Re: Database 'xxxx', OID yyyyy, has disappeared from pg_database

From: Michael Glenn <mike(at)mglenn(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Database 'xxxx', OID yyyyy, has disappeared from pg_database
Date: 2002-04-25 20:20:22
Message-ID: 3CC86506.3000302@mglenn.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Tom Lane wrote:

>Michael Glenn <mike(at)mglenn(dot)com> writes:
>
>
>>It's been quite a while since I've actually programmed in C but it
>>appears to have worked.
>>
>>
>
>Looks reasonable. Could I trouble you for the output with switches -f -i
>though? It's the item details we need.
>
>
Trouble me? I'm grateful your looking at at. Eternally grateful if you
can solve it.

Thanks again.

# ./pg_filedump -f -i /var/lib/pgsql/pg_database

*****************************************************************
* PostgreSQL File/Block Formatted Dump Utility
*
* File: /var/lib/pgsql/pg_database
* Options used: -f -i
*
* Dump created on: Thu Apr 25 16:07:22 2002
*****************************************************************

Block 0 ******************************************************
<Header> -----
Block Offset: 0x00000000 Offsets: Lower 160 (0x00a0)
Block Size: 8192 Upper 4896 (0x1320)
Special 8192 (0x2000)
Items: 38 Free Space: 4736
Length (including item array): 164

0000: a0002013 00200020 a89faa00 4c9fb200 .. .. . ....L...
0010: f89ea600 a89ea000 549ea200 f89db400 ........T.......
0020: a49da400 549da000 f09ab200 989aae00 ....T...........
0030: fc9caa00 a89ca800 449aa400 509cae00 ........D...P...
0040: f89baa00 f099a800 a49ba800 4c9bae00 ............L...
0050: 9c99a600 4899a200 f098ae00 9898aa00 ....H...........
0060: 3c98b200 e897a400 9497a400 3c97b000 <...........<...
0070: e896a800 8c96b400 3896a400 e095b000 ........8.......
0080: 8895ac00 2c95b800 d094b800 7494b800 ....,.......t...
0090: 1c94aa00 c893a800 7493a800 2093a800 ........t... ...
00a0: 00000000 ....

<Data> ------
Item 1 -- Length: 85 Offset: 8104 (0x1fa8) Flags: USED
OID: 17216 CID: min(0) max(0) XID: min(512) max(0)
Block Id: 0 linp Index: 1 Attributes: 4 Size: 32
infomask: 0x0902 (HASVARLENA|XMIN_COMMITTED|XMAX_INVALID)

1fa8: 40430000 00000000 00000000 00020000 @C..............
1fb8: 00000000 00000000 01000400 02092000 .............. .
1fc8: 74656d70 6c617465 31000000 00000000 template1.......
1fd8: 00000000 00000000 00000000 00000000 ................
1fe8: 1a000000 00000000 0d000000 74656d70 ............temp
1ff8: 6c617465 31 late1

Item 2 -- Length: 89 Offset: 8012 (0x1f4c) Flags: USED
OID: 18784 CID: min(0) max(0) XID: min(9750) max(0)
Block Id: 0 linp Index: 2 Attributes: 4 Size: 32
infomask: 0x0902 (HASVARLENA|XMIN_COMMITTED|XMAX_INVALID)

1f4c: 60490000 00000000 00000000 16260000 `I...........&..
1f5c: 00000000 00000000 02000400 02092000 .............. .
1f6c: 6e6f7274 68343964 65736967 6e000000 north49design...
1f7c: 00000000 00000000 00000000 00000000 ................
1f8c: f6010000 00000000 11000000 6e6f7274 ............nort
1f9c: 68343964 65736967 6e h49design

Item 3 -- Length: 83 Offset: 7928 (0x1ef8) Flags: USED
OID: 18816 CID: min(0) max(0) XID: min(9753) max(0)
Block Id: 0 linp Index: 3 Attributes: 4 Size: 32
infomask: 0x0902 (HASVARLENA|XMIN_COMMITTED|XMAX_INVALID)

1ef8: 80490000 00000000 00000000 19260000 .I...........&..
1f08: 00000000 00000000 03000400 02092000 .............. .
1f18: 636f6e74 72617800 00000000 00000000 contrax.........
1f28: 00000000 00000000 00000000 00000000 ................
1f38: f6010000 00000000 0b000000 636f6e74 ............cont
1f48: 726178 rax

Item 4 -- Length: 80 Offset: 7848 (0x1ea8) Flags: USED
OID: 18912 CID: min(0) max(0) XID: min(10768) max(0)
Block Id: 0 linp Index: 4 Attributes: 4 Size: 32
infomask: 0x0902 (HASVARLENA|XMIN_COMMITTED|XMAX_INVALID)

1ea8: e0490000 00000000 00000000 102a0000 .I...........*..
1eb8: 00000000 00000000 04000400 02092000 .............. .
1ec8: 6d696b65 00000000 00000000 00000000 mike............
1ed8: 00000000 00000000 00000000 00000000 ................
1ee8: f4010000 00000000 08000000 6d696b65 ............mike

Item 5 -- Length: 81 Offset: 7764 (0x1e54) Flags: USED
OID: 22240 CID: min(0) max(0) XID: min(17578) max(25203)
Block Id: 0 linp Index: 5 Attributes: 4 Size: 32
infomask: 0x0502 (HASVARLENA|XMIN_COMMITTED|XMAX_COMMITTED)

1e54: e0560000 00000000 00000000 aa440000 .V...........D..
1e64: 73620000 00000000 05000400 02052000 sb............ .
1e74: 666f726d 73000000 00000000 00000000 forms...........
1e84: 00000000 00000000 00000000 00000000 ................
1e94: f6010000 00000000 09000000 666f726d ............form
1ea4: 73 s

Item 6 -- Length: 90 Offset: 7672 (0x1df8) Flags: USED
OID: 22656 CID: min(0) max(0) XID: min(17781) max(0)
Block Id: 0 linp Index: 6 Attributes: 4 Size: 32
infomask: 0x0902 (HASVARLENA|XMIN_COMMITTED|XMAX_INVALID)

1df8: 80580000 00000000 00000000 75450000 .X..........uE..
1e08: 00000000 00000000 06000400 02092000 .............. .
1e18: 736f6e69 63626f6f 6d657261 6e670000 sonicboomerang..
1e28: 00000000 00000000 00000000 00000000 ................
1e38: f4010000 00000000 12000000 736f6e69 ............soni
1e48: 63626f6f 6d657261 6e67 cboomerang

Item 7 -- Length: 82 Offset: 7588 (0x1da4) Flags: USED
OID: 159456 CID: min(0) max(0) XID: min(170136) max(0)
Block Id: 0 linp Index: 7 Attributes: 4 Size: 32
infomask: 0x0902 (HASVARLENA|XMIN_COMMITTED|XMAX_INVALID)

1da4: e06e0200 00000000 00000000 98980200 .n..............
1db4: 00000000 00000000 07000400 02092000 .............. .
1dc4: 73627465 73740000 00000000 00000000 sbtest..........
1dd4: 00000000 00000000 00000000 00000000 ................
1de4: f7010000 00000000 0a000000 73627465 ............sbte
1df4: 7374 st

Item 8 -- Length: 80 Offset: 7508 (0x1d54) Flags: USED
OID: 109529120 CID: min(0) max(0) XID: min(24597178) max(0)
Block Id: 0 linp Index: 8 Attributes: 4 Size: 32
infomask: 0x0902 (HASVARLENA|XMIN_COMMITTED|XMAX_INVALID)

1d54: 20488706 00000000 00000000 ba527701 H...........Rw.
1d64: 00000000 00000000 08000400 02092000 .............. .
1d74: 6f616d6c 00000000 00000000 00000000 oaml............
1d84: 00000000 00000000 00000000 00000000 ................
1d94: f4010000 00000000 08000000 6f616d6c ............oaml

Item 9 -- Length: 89 Offset: 6896 (0x1af0) Flags: USED
OID: 133213920 CID: min(0) max(0) XID: min(34149469) max(0)
Block Id: 0 linp Index: 9 Attributes: 4 Size: 32
infomask: 0x0902 (HASVARLENA|XMIN_COMMITTED|XMAX_INVALID)

1af0: e0aef007 00000000 00000000 5d140902 ............]...
1b00: 00000000 00000000 09000400 02092000 .............. .
1b10: 736f6e69 635f6d69 67726174 65000000 sonic_migrate...
1b20: 00000000 00000000 00000000 00000000 ................
1b30: fb010000 00000000 11000000 736f6e69 ............soni
1b40: 635f6d69 67726174 65 c_migrate

Item 10 -- Length: 87 Offset: 6808 (0x1a98) Flags: USED
OID: 134734784 CID: min(0) max(0) XID: min(34161849) max(25403)
Block Id: 0 linp Index: 10 Attributes: 4 Size: 32
infomask: 0x0502 (HASVARLENA|XMIN_COMMITTED|XMAX_COMMITTED)

1a98: c0e30708 00000000 00000000 b9440902 .............D..
1aa8: 3b630000 00000000 0a000400 02052000 ;c............ .
1ab8: 70617261 76696e61 6c696100 00000000 paravinalia.....
1ac8: 00000000 00000000 00000000 00000000 ................
1ad8: f6010000 00000000 0f000000 70617261 ............para
1ae8: 76696e61 6c6961 vinalia

Item 11 -- Length: 85 Offset: 7420 (0x1cfc) Flags: USED
OID: 112770208 CID: min(0) max(0) XID: min(27544478) max(0)
Block Id: 0 linp Index: 11 Attributes: 4 Size: 32
infomask: 0x0902 (HASVARLENA|XMIN_COMMITTED|XMAX_INVALID)

1cfc: a0bcb806 00000000 00000000 9e4ba401 .............K..
1d0c: 00000000 00000000 0b000400 02092000 .............. .
1d1c: 63626170 74697374 65000000 00000000 cbaptiste.......
1d2c: 00000000 00000000 00000000 00000000 ................
1d3c: f8010000 00000000 0d000000 63626170 ............cbap
1d4c: 74697374 65 tiste

Item 12 -- Length: 84 Offset: 7336 (0x1ca8) Flags: USED
OID: 117208320 CID: min(0) max(0) XID: min(29728184) max(0)
Block Id: 0 linp Index: 12 Attributes: 4 Size: 32
infomask: 0x0902 (HASVARLENA|XMIN_COMMITTED|XMAX_INVALID)

1ca8: 0075fc06 00000000 00000000 b89dc501 .u..............
1cb8: 00000000 00000000 0c000400 02092000 .............. .
1cc8: 7a617869 736e6574 00000000 00000000 zaxisnet........
1cd8: 00000000 00000000 00000000 00000000 ................
1ce8: f9010000 00000000 0c000000 7a617869 ............zaxi
1cf8: 736e6574 snet

Item 13 -- Length: 82 Offset: 6724 (0x1a44) Flags: USED
OID: 134737440 CID: min(0) max(0) XID: min(34168449) max(29624)
Block Id: 0 linp Index: 13 Attributes: 4 Size: 32
infomask: 0x0502 (HASVARLENA|XMIN_COMMITTED|XMAX_COMMITTED)

1a44: 20ee0708 00000000 00000000 815e0902 ............^..
1a54: b8730000 00000000 0d000400 02052000 .s............ .
1a64: 6d676c65 6e6e0000 00000000 00000000 mglenn..........
1a74: 00000000 00000000 00000000 00000000 ................
1a84: f4010000 00000000 0a000000 6d676c65 ............mgle
1a94: 6e6e nn

Item 14 -- Length: 87 Offset: 7248 (0x1c50) Flags: USED
OID: 117208928 CID: min(0) max(0) XID: min(29740176) max(0)
Block Id: 0 linp Index: 14 Attributes: 4 Size: 32
infomask: 0x0902 (HASVARLENA|XMIN_COMMITTED|XMAX_INVALID)

1c50: 6077fc06 00000000 00000000 90ccc501 `w..............
1c60: 00000000 00000000 0e000400 02092000 .............. .
1c70: 6d61696c 696e676c 69737400 00000000 mailinglist.....
1c80: 00000000 00000000 00000000 00000000 ................
1c90: f4010000 00000000 0f000000 6d61696c ............mail
1ca0: 696e676c 697374 inglist

Item 15 -- Length: 85 Offset: 7160 (0x1bf8) Flags: USED
OID: 117260608 CID: min(0) max(0) XID: min(29761525) max(0)
Block Id: 0 linp Index: 15 Attributes: 4 Size: 32
infomask: 0x0902 (HASVARLENA|XMIN_COMMITTED|XMAX_INVALID)

1bf8: 4041fd06 00000000 00000000 f51fc601 @A..............
1c08: 00000000 00000000 0f000400 02092000 .............. .
1c18: 70686f6e 656c6973 74000000 00000000 phonelist.......
1c28: 00000000 00000000 00000000 00000000 ................
1c38: f9010000 00000000 0d000000 70686f6e ............phon
1c48: 656c6973 74 elist

Item 16 -- Length: 84 Offset: 6640 (0x19f0) Flags: USED
OID: 134741184 CID: min(0) max(0) XID: min(1653) max(0)
Block Id: 0 linp Index: 16 Attributes: 4 Size: 32
infomask: 0x0902 (HASVARLENA|XMIN_COMMITTED|XMAX_INVALID)

19f0: c0fc0708 00000000 00000000 75060000 ............u...
1a00: 00000000 00000000 10000400 02092000 .............. .
1a10: 706f7374 67726573 00000000 00000000 postgres........
1a20: 00000000 00000000 00000000 00000000 ................
1a30: 1a000000 00000000 0c000000 706f7374 ............post
1a40: 67726573 gres

Item 17 -- Length: 84 Offset: 7076 (0x1ba4) Flags: USED
OID: 118324000 CID: min(0) max(0) XID: min(29938908) max(0)
Block Id: 0 linp Index: 17 Attributes: 4 Size: 32
infomask: 0x0902 (HASVARLENA|XMIN_COMMITTED|XMAX_INVALID)

1ba4: 207b0d07 00000000 00000000 dcd4c801 {..............
1bb4: 00000000 00000000 11000400 02092000 .............. .
1bc4: 6375726f 7a6f6e65 00000000 00000000 curozone........
1bd4: 00000000 00000000 00000000 00000000 ................
1be4: fa010000 00000000 0c000000 6375726f ............curo
1bf4: 7a6f6e65 zone

Item 18 -- Length: 87 Offset: 6988 (0x1b4c) Flags: USED
OID: 118324032 CID: min(0) max(0) XID: min(29938910) max(0)
Block Id: 0 linp Index: 18 Attributes: 4 Size: 32
infomask: 0x0902 (HASVARLENA|XMIN_COMMITTED|XMAX_INVALID)

1b4c: 407b0d07 00000000 00000000 ded4c801 @{..............
1b5c: 00000000 00000000 12000400 02092000 .............. .
1b6c: 6375726f 6d61696c 696e6700 00000000 curomailing.....
1b7c: 00000000 00000000 00000000 00000000 ................
1b8c: fa010000 00000000 0f000000 6375726f ............curo
1b9c: 6d61696c 696e67 mailing

Item 19 -- Length: 83 Offset: 6556 (0x199c) Flags: USED
OID: 134741216 CID: min(0) max(0) XID: min(7683) max(0)
Block Id: 0 linp Index: 19 Attributes: 4 Size: 32
infomask: 0x0902 (HASVARLENA|XMIN_COMMITTED|XMAX_INVALID)

199c: e0fc0708 00000000 00000000 031e0000 ................
19ac: 00000000 00000000 13000400 02092000 .............. .
19bc: 74657374 696e6700 00000000 00000000 testing.........
19cc: 00000000 00000000 00000000 00000000 ................
19dc: f6010000 00000000 0b000000 74657374 ............test
19ec: 696e67 ing

Item 20 -- Length: 81 Offset: 6472 (0x1948) Flags: USED
OID: 134741344 CID: min(0) max(0) XID: min(25205) max(0)
Block Id: 0 linp Index: 20 Attributes: 4 Size: 32
infomask: 0x0902 (HASVARLENA|XMIN_COMMITTED|XMAX_INVALID)

1948: 60fd0708 00000000 00000000 75620000 `...........ub..
1958: 00000000 00000000 14000400 02092000 .............. .
1968: 666f726d 73000000 00000000 00000000 forms...........
1978: 00000000 00000000 00000000 00000000 ................
1988: f6010000 00000000 09000000 666f726d ............form
1998: 73 s

Item 21 -- Length: 87 Offset: 6384 (0x18f0) Flags: USED
OID: 134741696 CID: min(0) max(0) XID: min(25405) max(0)
Block Id: 0 linp Index: 21 Attributes: 4 Size: 32
infomask: 0x0902 (HASVARLENA|XMIN_COMMITTED|XMAX_INVALID)

18f0: c0fe0708 00000000 00000000 3d630000 ............=c..
1900: 00000000 00000000 15000400 02092000 .............. .
1910: 70617261 76696e61 6c696100 00000000 paravinalia.....
1920: 00000000 00000000 00000000 00000000 ................
1930: f6010000 00000000 0f000000 70617261 ............para
1940: 76696e61 6c6961 vinalia

Item 22 -- Length: 85 Offset: 6296 (0x1898) Flags: USED
OID: 134742816 CID: min(0) max(0) XID: min(28233) max(0)
Block Id: 0 linp Index: 22 Attributes: 4 Size: 32
infomask: 0x0902 (HASVARLENA|XMIN_COMMITTED|XMAX_INVALID)

1898: 20030808 00000000 00000000 496e0000 ...........In..
18a8: 00000000 00000000 16000400 02092000 .............. .
18b8: 73626665 61747572 65000000 00000000 sbfeature.......
18c8: 00000000 00000000 00000000 00000000 ................
18d8: f7010000 00000000 0d000000 73626665 ............sbfe
18e8: 61747572 65 ature

Item 23 -- Length: 89 Offset: 6204 (0x183c) Flags: USED
OID: 134743392 CID: min(0) max(0) XID: min(29471) max(0)
Block Id: 0 linp Index: 23 Attributes: 4 Size: 32
infomask: 0x0902 (HASVARLENA|XMIN_COMMITTED|XMAX_INVALID)

183c: 60050808 00000000 00000000 1f730000 `............s..
184c: 00000000 00000000 17000400 02092000 .............. .
185c: 7a617869 736e6574 666f7275 6d000000 zaxisnetforum...
186c: 00000000 00000000 00000000 00000000 ................
187c: f9010000 00000000 11000000 7a617869 ............zaxi
188c: 736e6574 666f7275 6d snetforum

Item 24 -- Length: 82 Offset: 6120 (0x17e8) Flags: USED
OID: 134743424 CID: min(0) max(0) XID: min(29628) max(0)
Block Id: 0 linp Index: 24 Attributes: 4 Size: 32
infomask: 0x0902 (HASVARLENA|XMIN_COMMITTED|XMAX_INVALID)

17e8: 80050808 00000000 00000000 bc730000 .............s..
17f8: 00000000 00000000 18000400 02092000 .............. .
1808: 6d676c65 6e6e0000 00000000 00000000 mglenn..........
1818: 00000000 00000000 00000000 00000000 ................
1828: f4010000 00000000 0a000000 6d676c65 ............mgle
1838: 6e6e nn

Item 25 -- Length: 82 Offset: 6036 (0x1794) Flags: USED
OID: 134752544 CID: min(0) max(0) XID: min(101415) max(0)
Block Id: 0 linp Index: 25 Attributes: 4 Size: 32
infomask: 0x0902 (HASVARLENA|XMIN_COMMITTED|XMAX_INVALID)

1794: 20290808 00000000 00000000 278c0100 )..........'...
17a4: 00000000 00000000 19000400 02092000 .............. .
17b4: 666f726d 616e0000 00000000 00000000 forman..........
17c4: 00000000 00000000 00000000 00000000 ................
17d4: f6010000 00000000 0a000000 666f726d ............form
17e4: 616e an

Item 26 -- Length: 88 Offset: 5948 (0x173c) Flags: USED
OID: 134753056 CID: min(0) max(0) XID: min(104992) max(0)
Block Id: 0 linp Index: 26 Attributes: 4 Size: 32
infomask: 0x0902 (HASVARLENA|XMIN_COMMITTED|XMAX_INVALID)

173c: 202b0808 00000000 00000000 209a0100 +.......... ...
174c: 00000000 00000000 1a000400 02092000 .............. .
175c: 666f726d 616e6d67 6c656e6e 00000000 formanmglenn....
176c: 00000000 00000000 00000000 00000000 ................
177c: f4010000 00000000 10000000 666f726d ............form
178c: 616e6d67 6c656e6e anmglenn

Item 27 -- Length: 84 Offset: 5864 (0x16e8) Flags: USED
OID: 134753984 CID: min(0) max(0) XID: min(105229) max(0)
Block Id: 0 linp Index: 27 Attributes: 4 Size: 32
infomask: 0x0902 (HASVARLENA|XMIN_COMMITTED|XMAX_INVALID)

16e8: c02e0808 00000000 00000000 0d9b0100 ................
16f8: 00000000 00000000 1b000400 02092000 .............. .
1708: 6e656564 74657874 00000000 00000000 needtext........
1718: 00000000 00000000 00000000 00000000 ................
1728: f6010000 00000000 0c000000 6e656564 ............need
1738: 74657874 text

Item 28 -- Length: 90 Offset: 5772 (0x168c) Flags: USED
OID: 134754016 CID: min(0) max(0) XID: min(105231) max(0)
Block Id: 0 linp Index: 28 Attributes: 4 Size: 32
infomask: 0x0902 (HASVARLENA|XMIN_COMMITTED|XMAX_INVALID)

168c: e02e0808 00000000 00000000 0f9b0100 ................
169c: 00000000 00000000 1c000400 02092000 .............. .
16ac: 666f726d 616e6e65 65647465 78740000 formanneedtext..
16bc: 00000000 00000000 00000000 00000000 ................
16cc: f6010000 00000000 12000000 666f726d ............form
16dc: 616e6e65 65647465 7874 anneedtext

Item 29 -- Length: 82 Offset: 5688 (0x1638) Flags: USED
OID: 134756288 CID: min(0) max(0) XID: min(119599) max(0)
Block Id: 0 linp Index: 29 Attributes: 4 Size: 32
infomask: 0x0902 (HASVARLENA|XMIN_COMMITTED|XMAX_INVALID)

1638: c0370808 00000000 00000000 2fd30100 .7........../...
1648: 00000000 00000000 1d000400 02092000 .............. .
1658: 67676c65 6e6e0000 00000000 00000000 gglenn..........
1668: 00000000 00000000 00000000 00000000 ................
1678: fc010000 00000000 0a000000 67676c65 ............ggle
1688: 6e6e nn

Item 30 -- Length: 88 Offset: 5600 (0x15e0) Flags: USED
OID: 134756320 CID: min(0) max(0) XID: min(119603) max(119609)
Block Id: 0 linp Index: 30 Attributes: 4 Size: 32
infomask: 0x0502 (HASVARLENA|XMIN_COMMITTED|XMAX_COMMITTED)

15e0: e0370808 00000000 00000000 33d30100 .7..........3...
15f0: 39d30100 00000000 1e000400 02052000 9............. .
1600: 666f726d 616e6767 6c656e6e 00000000 formangglenn....
1610: 00000000 00000000 00000000 00000000 ................
1620: fc010000 00000000 10000000 666f726d ............form
1630: 616e6767 6c656e6e angglenn

Item 31 -- Length: 86 Offset: 5512 (0x1588) Flags: USED
OID: 134756352 CID: min(0) max(0) XID: min(119605) max(0)
Block Id: 0 linp Index: 31 Attributes: 4 Size: 32
infomask: 0x0902 (HASVARLENA|XMIN_COMMITTED|XMAX_INVALID)

1588: 00380808 00000000 00000000 35d30100 .8..........5...
1598: 00000000 00000000 1f000400 02092000 .............. .
15a8: 676c656e 6e67726f 75700000 00000000 glenngroup......
15b8: 00000000 00000000 00000000 00000000 ................
15c8: fc010000 00000000 0e000000 676c656e ............glen
15d8: 6e67726f 7570 ngroup

Item 32 -- Length: 92 Offset: 5420 (0x152c) Flags: USED
OID: 134756384 CID: min(0) max(0) XID: min(119611) max(119636)
Block Id: 0 linp Index: 32 Attributes: 4 Size: 32
infomask: 0x0502 (HASVARLENA|XMIN_COMMITTED|XMAX_COMMITTED)

152c: 20380808 00000000 00000000 3bd30100 8..........;...
153c: 54d30100 00000000 20000400 02052000 T....... ..... .
154c: 666f726d 616e676c 656e6e67 726f7570 formanglenngroup
155c: 00000000 00000000 00000000 00000000 ................
156c: fc010000 00000000 14000000 666f726d ............form
157c: 616e676c 656e6e67 726f7570 anglenngroup

Item 33 -- Length: 92 Offset: 5328 (0x14d0) Flags: USED
OID: 134756800 CID: min(0) max(0) XID: min(119638) max(119704)
Block Id: 0 linp Index: 33 Attributes: 4 Size: 32
infomask: 0x0502 (HASVARLENA|XMIN_COMMITTED|XMAX_COMMITTED)

14d0: c0390808 00000000 00000000 56d30100 .9..........V...
14e0: 98d30100 00000000 21000400 02052000 ........!..... .
14f0: 666f726d 616e676c 656e6e67 726f7570 formanglenngroup
1500: 00000000 00000000 00000000 00000000 ................
1510: fc010000 00000000 14000000 666f726d ............form
1520: 616e676c 656e6e67 726f7570 anglenngroup

Item 34 -- Length: 92 Offset: 5236 (0x1474) Flags: USED
OID: 134757248 CID: min(0) max(0) XID: min(119706) max(0)
Block Id: 0 linp Index: 34 Attributes: 4 Size: 32
infomask: 0x0902 (HASVARLENA|XMIN_COMMITTED|XMAX_INVALID)

1474: 803b0808 00000000 00000000 9ad30100 .;..............
1484: 00000000 00000000 22000400 02092000 ........"..... .
1494: 666f726d 616e676c 656e6e67 726f7570 formanglenngroup
14a4: 00000000 00000000 00000000 00000000 ................
14b4: fc010000 00000000 14000000 666f726d ............form
14c4: 616e676c 656e6e67 726f7570 anglenngroup

Item 35 -- Length: 85 Offset: 5148 (0x141c) Flags: USED
OID: 134768768 CID: min(0) max(0) XID: min(192999) max(0)
Block Id: 0 linp Index: 35 Attributes: 4 Size: 32
infomask: 0x0902 (HASVARLENA|XMIN_COMMITTED|XMAX_INVALID)

141c: 80680808 00000000 00000000 e7f10200 .h..............
142c: 00000000 00000000 23000400 02092000 ........#..... .
143c: 67666361 74616c6f 67000000 00000000 gfcatalog.......
144c: 00000000 00000000 00000000 00000000 ................
145c: fd010000 00000000 0d000000 67666361 ............gfca
146c: 74616c6f 67 talog

Item 36 -- Length: 84 Offset: 5064 (0x13c8) Flags: USED
OID: 134768896 CID: min(0) max(0) XID: min(208243) max(0)
Block Id: 0 linp Index: 36 Attributes: 4 Size: 32
infomask: 0x0902 (HASVARLENA|XMIN_COMMITTED|XMAX_INVALID)

13c8: 00690808 00000000 00000000 732d0300 .i..........s-..
13d8: 00000000 00000000 24000400 02092000 ........$..... .
13e8: 666f726d 616e6766 00000000 00000000 formangf........
13f8: 00000000 00000000 00000000 00000000 ................
1408: fd010000 00000000 0c000000 666f726d ............form
1418: 616e6766 angf

Item 37 -- Length: 84 Offset: 4980 (0x1374) Flags: USED
OID: 134771424 CID: min(0) max(0) XID: min(265193) max(0)
Block Id: 0 linp Index: 37 Attributes: 4 Size: 32
infomask: 0x0902 (HASVARLENA|XMIN_COMMITTED|XMAX_INVALID)

1374: e0720808 00000000 00000000 e90b0400 .r..............
1384: 00000000 00000000 25000400 02092000 ........%..... .
1394: 63746d62 6f617264 00000000 00000000 ctmboard........
13a4: 00000000 00000000 00000000 00000000 ................
13b4: fe010000 00000000 0c000000 63746d62 ............ctmb
13c4: 6f617264 oard

Item 38 -- Length: 84 Offset: 4896 (0x1320) Flags: USED
OID: 134771488 CID: min(0) max(0) XID: min(266012) max(0)
Block Id: 0 linp Index: 38 Attributes: 4 Size: 32
infomask: 0x0902 (HASVARLENA|XMIN_COMMITTED|XMAX_INVALID)

1320: 20730808 00000000 00000000 1c0f0400 s..............
1330: 00000000 00000000 26000400 02092000 ........&..... .
1340: 666f726d 616e6374 00000000 00000000 formanct........
1350: 00000000 00000000 00000000 00000000 ................
1360: fe010000 00000000 0c000000 666f726d ............form
1370: 616e6374 anct

*** End of File Encountered. Last Block Read: 0 ***

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Bruce Momjian 2002-04-25 20:33:49 Re: pg_restore and permissions
Previous Message Tom Lane 2002-04-25 20:10:13 Re: Database 'xxxx', OID yyyyy, has disappeared from pg_database