Обсуждение: Read db files directly

Поиск
Список
Период
Сортировка

Read db files directly

От
Mingzuo Shen
Дата:
Hello,

I see some OS files (50+ GB total) but cannot see
anything in psql -l.
There seem to be some big tables there.
I wonder if there are some tools that would dump the
tables in text.
or, how to make PostgreSQL "connect" to these files
again?
Thanks in advance!

psql -V
psql (PostgreSQL) 7.2.2

the original DBA is no longer "available".


-rw-------    1 postgres postgres 932921344 May 14
20:43 1076888071
-rw-------    1 postgres postgres     8192 May 14
20:43 1076911034
-rw-------    1 postgres postgres        0 Feb 13
2004 1076911036
-rw-------    1 postgres postgres     8192 Feb 13
2004 1076911038
-rw-------    1 postgres postgres    32768 Jul 22
14:47 1247
-rw-------    1 postgres postgres   360448 Jul 22
14:47 1249
-rw-------    1 postgres postgres   253952 Feb 13
2004 1255
-rw-------    1 postgres postgres    65536 Jul 22
14:51 1259
-rw-------    1 postgres postgres 1073741824 Jun  8
2005 1338809055
-rw-------    1 postgres postgres 1073741824 Jun 11
2005 1338809055.1
-rw-------    1 postgres postgres 1073741824 Jul 11
2005 1338809055.10
-rw-------    1 postgres postgres 837844992 May 14
20:51 1338809055.11
-rw-------    1 postgres postgres 1073741824 Jun 15
2005 1338809055.2
-rw-------    1 postgres postgres 1073741824 Jun 18
2005 1338809055.3
-rw-------    1 postgres postgres 1073741824 Jun 21
2005 1338809055.4
-rw-------    1 postgres postgres 1073741824 Jun 23
2005 1338809055.5
-rw-------    1 postgres postgres 1073741824 Jun 27
2005 1338809055.6
-rw-------    1 postgres postgres 1073741824 Jun 29
2005 1338809055.7
-rw-------    1 postgres postgres 1073741824 Jul  5
2005 1338809055.8
-rw-------    1 postgres postgres 1073741824 Jul  7
2005 1338809055.9
-rw-------    1 postgres postgres 160129024 May 14
20:51 1338809163
-rw-------    1 postgres postgres 140402688 May 14
20:51 1338809165
-rw-------    1 postgres postgres 1073741824 Feb 13
2004 1411100549
-rw-------    1 postgres postgres 1073741824 Feb 13
2004 1411100549.1
-rw-------    1 postgres postgres 139853824 Feb 13
2004 1411100549.2
-rw-------    1 postgres postgres 26640384 Feb 13
2004 1519546462
-rw-------    1 postgres postgres 616554496 Feb 13
2004 1527610042
-rw-------    1 postgres postgres   180224 Feb 13
2004 1527676219
-rw-------    1 postgres postgres 1073741824 Feb 13
2004 1558949218
-rw-------    1 postgres postgres 1073741824 Feb 13
2004 1558949218.1
-rw-------    1 postgres postgres 367534080 Feb 13
2004 1558949218.2
-rw-------    1 postgres postgres 1014079488 Feb 13
2004 1558955870
-rw-------    1 postgres postgres 78544896 May 14
20:55 1560852916
-rw-------    1 postgres postgres  3121152 Apr  5
2004 1573041194
-rw-------    1 postgres postgres  6012928 Apr  6
2004 1573041225
-rw-------    1 postgres postgres   958464 Feb 13
2004 1573041235
-rw-------    1 postgres postgres  1843200 Feb 13
2004 1573041254
-rw-------    1 postgres postgres  7020544 Feb 13
2004 1600656072
-rw-------    1 postgres postgres 11509760 Feb 13
2004 1600927397
-rw-------    1 postgres postgres 43499520 Dec 16
2004 1600949827
-rw-------    1 postgres postgres 1073741824 Feb 13
2004 1637104512
-rw-------    1 postgres postgres 1073741824 Feb 13
2004 1637104512.1
-rw-------    1 postgres postgres 1073741824 Feb 13
2004 1637104512.2
-rw-------    1 postgres postgres 1073741824 Feb 13
2004 1637104512.3
-rw-------    1 postgres postgres 1073741824 Feb 13
2004 1637104512.4
-rw-------    1 postgres postgres 563847168 Feb 13
2004 1637104512.5
-rw-------    1 postgres postgres 1073741824 Feb 13
2004 1637110994
-rw-------    1 postgres postgres 841973760 Feb 13
2004 1637110994.1
-rw-------    1 postgres postgres        0 Feb 13
2004 16384
-rw-------    1 postgres postgres        0 Feb 13
2004 16386
-rw-------    1 postgres postgres        0 Feb 13
2004 16388
-rw-------    1 postgres postgres    16384 Jul 22
14:51 16390
-rw-------    1 postgres postgres    81920 Feb 13
2004 16392
-rw-------    1 postgres postgres     8192 Feb 13
2004 16394
-rw-------    1 postgres postgres     8192 Feb 13
2004 16396
-rw-------    1 postgres postgres    16384 Feb 13
2004 16398
-rw-------    1 postgres postgres     8192 Feb 13
2004 16400
-rw-------    1 postgres postgres     8192 Feb 13
2004 16402
-rw-------    1 postgres postgres        0 Feb 13
2004 16404
-rw-------    1 postgres postgres     8192 Feb 13
2004 16406
-rw-------    1 postgres postgres   270336 May 14
20:42 16408
-rw-------    1 postgres postgres    32768 Feb 13
2004 16410
-rw-------    1 postgres postgres     8192 Feb 13
2004 16412
-rw-------    1 postgres postgres        0 Feb 13
2004 16414
-rw-------    1 postgres postgres    98304 Feb 13
2004 16416
-rw-------    1 postgres postgres    16384 Feb 13
2004 16418
-rw-------    1 postgres postgres    16384 Feb 13
2004 16419
-rw-------    1 postgres postgres    16384 Feb 13
2004 16420
-rw-------    1 postgres postgres    16384 Feb 13
2004 16421
-rw-------    1 postgres postgres    16384 Feb 13
2004 16422
-rw-------    1 postgres postgres    16384 Feb 13
2004 16423
-rw-------    1 postgres postgres    16384 Feb 13
2004 16424
-rw-------    1 postgres postgres     8192 Feb 13
2004 16425
-rw-------    1 postgres postgres   303104 Jul 22
14:51 16426
-rw-------    1 postgres postgres   131072 Jul 22
14:51 16427
-rw-------    1 postgres postgres    16384 Jul 22
14:51 16428
-rw-------    1 postgres postgres    49152 Jul 22
14:51 16429
-rw-------    1 postgres postgres    57344 Feb 13
2004 16432
-rw-------    1 postgres postgres    16384 May 14
20:42 16435
-rw-------    1 postgres postgres    16384 May 14
20:42 16436
-rw-------    1 postgres postgres     8192 Feb 13
2004 16437
-rw-------    1 postgres postgres    16384 Feb 13
2004 16438
-rw-------    1 postgres postgres    16384 Feb 13
2004 16439
-rw-------    1 postgres postgres     8192 Feb 13
2004 16440
-rw-------    1 postgres postgres    16384 Feb 13
2004 16441
-rw-------    1 postgres postgres    16384 Feb 13
2004 16442
-rw-------    1 postgres postgres    32768 Feb 13
2004 16443
-rw-------    1 postgres postgres    65536 Feb 13
2004 16444
-rw-------    1 postgres postgres    49152 Feb 13
2004 16445
-rw-------    1 postgres postgres   237568 Feb 13
2004 16446
-rw-------    1 postgres postgres     8192 Feb 13
2004 16447
-rw-------    1 postgres postgres    16384 Feb 13
2004 16448
-rw-------    1 postgres postgres    16384 Feb 13
2004 16449
-rw-------    1 postgres postgres    32768 Mar 25
2004 16452
-rw-------    1 postgres postgres    16384 Feb 13
2004 16453
-rw-------    1 postgres postgres    16384 Feb 13
2004 16454
-rw-------    1 postgres postgres    16384 Feb 13
2004 16455
-rw-------    1 postgres postgres    16384 Feb 13
2004 16456
-rw-------    1 postgres postgres    16384 Jul 22
14:51 16457
-rw-------    1 postgres postgres    32768 Jul 22
14:51 16458
-rw-------    1 postgres postgres        0 Feb 13
2004 16460
-rw-------    1 postgres postgres     8192 Feb 13
2004 16462
-rw-------    1 postgres postgres        0 Feb 13
2004 16463
-rw-------    1 postgres postgres     8192 Feb 13
2004 16465
-rw-------    1 postgres postgres        0 Feb 13
2004 16466
-rw-------    1 postgres postgres     8192 Feb 13
2004 16468
-rw-------    1 postgres postgres        0 Feb 13
2004 16469
-rw-------    1 postgres postgres     8192 Feb 13
2004 16471
-rw-------    1 postgres postgres    16384 Feb 13
2004 16472
-rw-------    1 postgres postgres    16384 Feb 13
2004 16474
-rw-------    1 postgres postgres        0 Feb 13
2004 16475
-rw-------    1 postgres postgres     8192 Feb 13
2004 16477
-rw-------    1 postgres postgres 1073741824 May 24
2004 1715778033
-rw-------    1 postgres postgres 1073741824 May 24
2004 1715778033.1
-rw-------    1 postgres postgres 211279872 May 14
21:15 1715778033.10
-rw-------    1 postgres postgres 1073741824 May 24
2004 1715778033.2
-rw-------    1 postgres postgres 1073741824 May 24
2004 1715778033.3
-rw-------    1 postgres postgres 1073741824 May 24
2004 1715778033.4
-rw-------    1 postgres postgres 1073741824 May 24
2004 1715778033.5
-rw-------    1 postgres postgres 1073741824 May 24
2004 1715778033.6
-rw-------    1 postgres postgres 1073741824 May 24
2004 1715778033.7
-rw-------    1 postgres postgres 1073741824 May 14
21:13 1715778033.8
-rw-------    1 postgres postgres 1073741824 May 14
21:15 1715778033.9
-rw-------    1 postgres postgres 1073741824 Feb 13
2004 1829259384
-rw-------    1 postgres postgres 1073741824 Feb 13
2004 1829259384.1
-rw-------    1 postgres postgres 247996416 Feb 13
2004 1829259384.2
-rw-------    1 postgres postgres 730816512 Feb 13
2004 1837299515
-rw-------    1 postgres postgres 75956224 Feb 13
2004 1934262674
-rw-------    1 postgres postgres 1026228224 May 14
21:07 2140124652
-rw-------    1 postgres postgres 196026368 May 14
21:06 2149234748
-rw-------    1 postgres postgres 171352064 May 14
21:07 2149300741
-rw-------    1 postgres postgres     8192 Mar  5
2004 2156705278
-rw-------    1 postgres postgres   434176 Mar  5
2004 2156715705
-rw-------    1 postgres postgres 355672064 Mar 15
2004 2253565510
-rw-------    1 postgres postgres     8192 May 24
2004 3475308772
-rw-------    1 postgres postgres 105922560 May 24
2004 3475503001
-rw-------    1 postgres postgres 22298624 May 24
2004 3476856707
-rw-------    1 postgres postgres 1073741824 May 24
2004 3476895975
-rw-------    1 postgres postgres 1073741824 May 24
2004 3476895975.1
-rw-------    1 postgres postgres 1073741824 May 24
2004 3476895975.2
-rw-------    1 postgres postgres 1073741824 May 24
2004 3476895975.3
-rw-------    1 postgres postgres 1073741824 May 24
2004 3476895975.4
-rw-------    1 postgres postgres 1073741824 May 24
2004 3476895975.5
-rw-------    1 postgres postgres 1030725632 May 24
2004 3476895975.6
-rw-------    1 postgres postgres 383729664 May 27
2004 3625785642
-rw-------    1 postgres postgres 1073741824 Jun  2
2004 3667355595
-rw-------    1 postgres postgres 1073741824 Jun  2
2004 3667355595.1
-rw-------    1 postgres postgres 1073741824 Jun  4
2004 3667355595.2
-rw-------    1 postgres postgres 1073741824 Jun  4
2004 3667355595.3
-rw-------    1 postgres postgres 1073741824 Jun  4
2004 3667355595.4
-rw-------    1 postgres postgres 835903488 May 14
21:25 3667355595.5
-rw-------    1 postgres postgres     1800 May 15
21:44 pg_internal.init
drwx------    2 postgres postgres     4096 Jul 16
20:40 pgsql_tmp
-rw-------    1 postgres postgres        4 Feb 13
2004 PG_VERSION