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@xxxxxxxxxxxxxxxxxxxxxx> 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.
