pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Mingzuo Shen <mzshen@yahoo.com>
To: pgsql-admin@postgresql.org
Subject: Re: Read db files directly
Date: Fri, 28 Jul 2006 14:19:46 -0700 (PDT)
Message-ID: <20060728211946.26290.qmail@web60417.mail.yahoo.com> (raw)
In-Reply-To: <Pine.LNX.4.64.0607281331130.11632@discord.home.frostconsultingllc.com>

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.



--- Jeff Frost <jeff@frostconsultingllc.com> wrote:

> So what are the two locations in question?  Is one
> /var/lib/pgsql/data and 
> another one /usr/local/pgsql/data by chance?
> 
> You can start another instance of postmaster in that
> directory by using:
> 
> pg_ctl -D <path to data directory> start
> 
> example:
> 
> pg_ctl -D /usr/local/pgsql/data start
> 
> If you do a ps -ef | grep data, you should probably
> see something like:
> 
> postgres 20991     1  4 13:33 pts/13   00:00:00
> /usr/bin/postmaster -p 5432 -D 
> /var/lib/pgsql/data
> 
> which would tell you that the current instance of
> postgres is running in 
> /var/lib/pgsql/data and you need to start the other
> one up to see what's in 
> the other location.
> 
> On Fri, 28 Jul 2006, Mingzuo Shen wrote:
> 
> > Thanks Scott.
> > That is a much clearer way of putting it.
> > That old PostgreSQL runs just fine,
> > in one place, but I have 50 GB of files in
> > another place. PostgreSQL is not reading it.
> > How can I persuade this PostgreSQL,
> > or any PostgeSQL, to read that 50 GB of files.
> > Or any independent tool to read the files.
> >
> > Tom Lane mentioned "vacuum".
> > If only I knew the database name,
> > I could try "psql dbname".
> > But I don't know the database name either.
> > I did run "vacuum" in my new testdb.
> >
> > Yeah. I guess the previous DBA put those files
> > on a different file system,
> > and then forgot about them, probably with
> > good reason. But as I said, the previous DBA
> > is no longer available.
> >
> > Imagine I send just those files to you,
> > and you try to get some text out of them.
> > I do not have the SQL used to create
> > the tables, no table structures.
> >
> >
> >
> > --- Scott Marlowe <smarlowe@g2switchworks.com>
> wrote:
> >
> >> It sounds like the current postgresql is running
> in
> >> one directory, and
> >> you're looking in another directory.  If you can
> see
> >> how postgresql was
> >> started, does it have a -D switch that shows the
> >> directory?  My guess is
> >> you could chmod 000 the master directory you're
> >> looking at right now and
> >> postgresql could still startup, because it's not
> >> where you think it is.
> >
> >
> > ---------------------------(end of
> broadcast)---------------------------
> > TIP 3: Have you checked our extensive FAQ?
> >
> >               http://www.postgresql.org/docs/faq
> >
> >
> 
> -- 
> Jeff Frost, Owner 	<jeff@frostconsultingllc.com>
> Frost Consulting, LLC 
> http://www.frostconsultingllc.com/
> Phone: 650-780-7908	FAX: 650-649-1954
> 




view thread (15+ messages)  latest in thread

Message-ID: <20060728211946.26290.qmail@web60417.mail.yahoo.com>
Permalink:  ../20060728211946.26290.qmail@web60417.mail.yahoo.com/
Also on:    postgresql.org/message-id/20060728211946.26290.qmail@web60417.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
  Subject: Re: Read db files directly
  In-Reply-To: <20060728211946.26290.qmail@web60417.mail.yahoo.com>
  References: <Pine.LNX.4.64.0607281331130.11632@discord.home.frostconsultingllc.com> <20060728211946.26290.qmail@web60417.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