From: | Mingzuo Shen <mzshen(at)yahoo(dot)com> |
---|---|
To: | Jeff Frost <jeff(at)frostconsultingllc(dot)com> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Read db files directly |
Date: | 2006-07-29 09:55:36 |
Message-ID: | 20060729095536.85729.qmail@web60414.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)frostconsultingllc(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Andy Shellam | 2006-07-29 10:28:47 | Re: Read db files directly |
Previous Message | Mostafizur Rahaman Sohel | 2006-07-29 09:45:01 | Scheduled backup in postgresql |