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 A83BA9FB27A for ; Fri, 28 Jul 2006 16:43:43 -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 81105-01 for ; Fri, 28 Jul 2006 16:43:37 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from web60416.mail.yahoo.com (web60416.mail.yahoo.com [209.73.178.144]) by postgresql.org (Postfix) with SMTP id A327D9FB279 for ; Fri, 28 Jul 2006 16:43:06 -0300 (ADT) Received: (qmail 67351 invoked by uid 60001); 28 Jul 2006 19:43:01 -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=qfsn3JmI84b9exomfjZUJVJ3B+aNEFLzR2jBLpKDH3CkLGTNjxpjqLiVPkllQ1yZpv/mWmD7Axs5nPdPi2GQIcei6Y8zavSjAkNHNH3IHJzpMnhFu1HVVcNIVQqw5T/gufhcCfBNYvoSeJ45TsHRv6wxHJnIaKVq2Cn//Jbs0+M= ; Message-ID: <20060728194301.67345.qmail@web60416.mail.yahoo.com> Received: from [128.249.216.224] by web60416.mail.yahoo.com via HTTP; Fri, 28 Jul 2006 12:43:01 PDT Date: Fri, 28 Jul 2006 12:43:01 -0700 (PDT) From: Mingzuo Shen Subject: Re: Read db files directly To: Scott Marlowe Cc: pgsql-admin@postgresql.org In-Reply-To: <1154115153.31664.129.camel@state.g2switchworks.com> 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=2.829 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, DNS_FROM_RFC_WHOIS X-Spam-Level: ** X-Archive-Number: 200607/269 X-Sequence-Number: 22515 Thanks Scott. Well, PostgreSQL runs just fine. As I said, I can create new db, new tables, etc. everything works just fine for new stuff. when I say psql shows nothing, I really mean "nothing". No error messages. Of course if I create a new db, psql -l shows my new db. psql -l List of databases Name | Owner | Encoding --------+----------+----------- testdb | postgres | SQL_ASCII (1 row) What I am curious about is, what are in those 50 GB worth of files. "strings" shows me there are some data that I might be interested in saving before I erase this pg instance. --- Scott Marlowe wrote: > Can you get postgresql to startup? Are you trying > to use pg_ctl to > start it or /etc/init.d/postgresql scripts? > > Basically, you need the database up and running > first. When you "psql > and pg_dump don't see those files" what errors are > you actually getting? > > On Fri, 2006-07-28 at 14:23, Mingzuo Shen wrote: > > Thanks Aaron. > > > > No. pg_dump, psql do not "see" those files. > > As I said, psql -l shows "nothing". > > pg_dumpall outputs nothing. > > > > strings 3476895975 > > > > for example, does show a lot of text, > > some of them seem to be actual data > > that I am interested in extracting. > > > > If I create a new db and create new tables > > in the new db, then they work as usual. > > > > > > > > --- Aaron Bono wrote: > > > > > On 7/22/06, Shen, Mingzuo wrote: > > > > > > > > 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? > > > > > > > > > > You can dump the whole database contents with > > > pg_dump. This dumps your > > > whole database with data into a text file. Is > this > > > what you mean? > > > > > > > > > ================================================================== > > > Aaron Bono > > > Aranya Software Technologies, Inc. > > > http://www.aranya.com > > > > > > ================================================================== > > > > > > > > > ---------------------------(end of > broadcast)--------------------------- > > TIP 5: don't forget to increase your free space > map settings >