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

Поиск
Список
Период
Сортировка
От Michael Glenn
Тема Re: Database 'xxxx', OID yyyyy, has disappeared from pg_database
Дата
Msg-id 3CC86506.3000302@mglenn.com
обсуждение исходный текст
Ответ на Re: Database 'xxxx', OID yyyyy, has disappeared from pg_database  (Michael Glenn <mike@mglenn.com>)
Ответы Re: Database 'xxxx', OID yyyyy, has disappeared from pg_database  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
Tom Lane wrote:

>Michael Glenn <mike@mglenn.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 ***





В списке pgsql-admin по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Database 'xxxx', OID yyyyy, has disappeared from pg_database
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: pg_restore and permissions