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
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
-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