Hello,
I tried creating the files 0000 through 002F. Pg_dump still will not
run. The error was as follows:
-bash-3.00$ pg_dump -U postgres ebiz > ebiz_bk.sql
pg_dump: SQL command failed
pg_dump: Error message from server: ERROR: could not access status
of transaction 20080015
DETAIL: Could not read from file "pg_clog/0013" at offset 32768:
Error 0.
pg_dump: The command was: COPY ebizd.products_categories
(category_id, product_id) TO stdout;
Carol
On Sep 24, 2008, at 7:13 AM, Walter, Carol Williams wrote:
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
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin