From: Mingzuo Shen <mzshen@yahoo.com>
To: Jeff Frost <jeff@frostconsultingllc.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Read db files directly
Date: Sat, 29 Jul 2006 02:55:36 -0700 (PDT)
Message-ID: <20060729095536.85729.qmail@web60414.mail.yahoo.com> (raw)
In-Reply-To: <Pine.LNX.4.64.0607281923440.11632@discord.home.frostconsultingllc.com>
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 <jeff@frostconsultingllc.com> 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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: mzshen@yahoo.com, jeff@frostconsultingllc.com
Subject: Re: Read db files directly
In-Reply-To: <20060729095536.85729.qmail@web60414.mail.yahoo.com>
References: <Pine.LNX.4.64.0607281923440.11632@discord.home.frostconsultingllc.com> <20060729095536.85729.qmail@web60414.mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox