Hello,
I will try this. Is there a particular size these files need to be?
Then I can try the pg_dumpall. That's, of course, my main concern. I
need to get the data out.
By the way, before I went to panic mode, I tried pg_dumpall and
reindexing the database. Everything gets the same error, perhaps with
a different file name.
Carol
Quoting Scott Marlowe <[EMAIL PROTECTED]>:
On Tue, Sep 23, 2008 at 10:16 PM, Tena Sakai <[EMAIL PROTECTED]> wrote:
Hi Carol,
I detect in you some apprehension as to pg_dumpall
won't run or complete. Why is that? Have you already
done it and it didn't work? If that's not the case,
why not run pg_dumpall at a quiet hour and see?
I think Scott is right as to install the latest
8.2 on top. It won't be time consuming task.
Why not give it a wheel? It would be good to
find out one way or the other.
Scott: Are files 0000 through 002F (which are
not there) absolutely necessary for recovering data?
Most likely not. If the db won't start up without them, it might be
possible to create new clog files that are nothing but zeroes. Never
been in this position though...
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin