pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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.




view thread (15+ messages)  latest in thread

Message-ID: <20060729095536.85729.qmail@web60414.mail.yahoo.com>
Permalink:  ../20060729095536.85729.qmail@web60414.mail.yahoo.com/
Also on:    postgresql.org/message-id/20060729095536.85729.qmail@web60414.mail.yahoo.com

 · 

reply

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