Re: Read db files directly - Mailing list pgsql-admin

From Mingzuo Shen
Subject Re: Read db files directly
Date
Msg-id 20060729095536.85729.qmail@web60414.mail.yahoo.com
Whole thread Raw
In response to Re: Read db files directly  (Jeff Frost <jeff@frostconsultingllc.com>)
Responses Re: Read db files directly
List pgsql-admin
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.


pgsql-admin by date:

Previous
From: Jeff Frost
Date:
Subject: Re: Read db files directly
Next
From: Andy Shellam
Date:
Subject: Re: Read db files directly