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 AC0FC9FB2AE for ; Sat, 29 Jul 2006 06:55:57 -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 49491-04 for ; Sat, 29 Jul 2006 06:55:41 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from web60414.mail.yahoo.com (web60414.mail.yahoo.com [209.73.178.157]) by postgresql.org (Postfix) with SMTP id E90059FB2AA for ; Sat, 29 Jul 2006 06:55:39 -0300 (ADT) Received: (qmail 85731 invoked by uid 60001); 29 Jul 2006 09:55:36 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=L6GXqmlsFVRLHebz4s4J8Ik7c+xCNwCzRtkaEddxaSfrXmwoU5nFdt1aYdlK5lcdAH+Q++HOWtJQ4i+5/PLLiYIajPUNr04/WINocj918fUoD8kf3eUJU5953vf9ch/fC3Mwh5j2H6X7m3C8CSKDwiXxFGxiDr47Erp5h786pog= ; Message-ID: <20060729095536.85729.qmail@web60414.mail.yahoo.com> Received: from [128.249.216.224] by web60414.mail.yahoo.com via HTTP; Sat, 29 Jul 2006 02:55:36 PDT Date: Sat, 29 Jul 2006 02:55:36 -0700 (PDT) From: Mingzuo Shen Subject: Re: Read db files directly To: Jeff Frost Cc: pgsql-admin@postgresql.org In-Reply-To: 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=1.415 tagged_above=0 required=5 tests=AWL X-Spam-Level: * X-Archive-Number: 200607/276 X-Sequence-Number: 22522 Sorry I did not make it clear. I still do not see the db, tables, etc. vacuumdb, pg_dumpdball, psql, etc that requires a normal PostgreSQL do not see the db. Tried them all, many times. --- Jeff Frost wrote: > So, is the working postmaster running in > /var/lib/pgsql/data? > > Have you taken Tom's advice and run 'VACUUM > pg_database' ? Or even just > 'vacuumdb -av' ? > > On Fri, 28 Jul 2006, Mingzuo Shen wrote: > > > Thanks Jeff! > > > > No, cannot do that. > > Because the folder has only the "oid" files. > > Don't know that to call them. > > All file names are numbers. > > Except the three following: > > pg_internal.init > > pgsql_tmp (empty folder) > > PG_VERSION > > > > /seagate400/1061329089 is the actual location > > of those 50 GB worth of files. > > I have a symlink like so: > > /var/lib/pgsql/data/base/1061329089 > > -> > > /seagate400/1061329089 > > Restarted many times.