Re: Read db files directly

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.