Read db files directly
| От | Mingzuo Shen |
|---|---|
| Тема | Read db files directly |
| Дата | |
| Msg-id | 20060723200234.18410.qmail@web60425.mail.yahoo.com обсуждение исходный текст |
| Список | pgsql-admin |
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
В списке pgsql-admin по дате отправления: