X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 183FD9FA47F for ; Sun, 23 Jul 2006 17:02:46 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 18523-05 for ; Sun, 23 Jul 2006 17:02:37 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from web60425.mail.yahoo.com (web60425.mail.yahoo.com [209.73.178.153]) by postgresql.org (Postfix) with SMTP id 978169FA1E2 for ; Sun, 23 Jul 2006 17:02:35 -0300 (ADT) Received: (qmail 18412 invoked by uid 60001); 23 Jul 2006 20:02:34 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=VNG2jBEubDSnuVC5YFfJF4/Zv7i/hRdvggwzkR4bVjR+VvO4ZFgY5g40HacjRp+1y+4LHK72dg8ExKS6mz88z1A8nvjDuO2Rrs8JOrw/Yse8HnfcrqW5RH9Q0Vg0nrtkw8laL/GzaYFbQaZKZJhgwtvzjBsdoqbo2npp7e5ISmw= ; Message-ID: <20060723200234.18410.qmail@web60425.mail.yahoo.com> Received: from [128.249.216.224] by web60425.mail.yahoo.com via HTTP; Sun, 23 Jul 2006 13:02:33 PDT Date: Sun, 23 Jul 2006 13:02:33 -0700 (PDT) From: Mingzuo Shen Subject: Read db files directly To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=3.355 tagged_above=0 required=5 tests=DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, DNS_FROM_RFC_WHOIS X-Spam-Level: *** X-Archive-Number: 200607/182 X-Sequence-Number: 22428 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