Hi,
I am running postgres-8.1 on a Centos5 system.
this morning when I came in there was no more disk space on the
partition that holds pgsql: /var/lib/pgsql.
I believe postgres had crashed at this point. I stupidly removed all of
the files under pg_xlog to create disk space. Not knowing that those
are the files I need to start the database. I quickly realized the
error I had made and restored the pg_xlog data/files from our system
backup that ran at 1am last night (4/22/08).
Now when I try to restart the database, I get the following error. It
is looking for file 000000010000001300000064, which I do not have.
LOG: database system was shut down at 2008-04-22 10:38:59 EDT
LOG: could not open file "pg_xlog/" (log file 19, segment 100): No such
file or directory
LOG: invalid primary checkpoint record
LOG: could not open file "pg_xlog/000000010000001300000064" (log file
19, segment 100): No such file or directory
LOG: invalid secondary checkpoint record
PANIC: could not locate a valid checkpoint record
LOG: startup process (PID 6800) was terminated by signal 6
LOG: aborting startup due to startup process failure
LOG: logger shutting down
I am in the process of having the WAL dir restored as well. Again, in
my haste, I deleted that dir as well. This data will be from 4/22/08 at
1pm as well, time of the system backup.
If I do not have the files that startup script is asking for, what is
the best way to restart the database.
Any advise (other than not deleting im****tant dirs) would be greatly
appreciated.
--
Thanks
Mary Ellen
--
Sent via pgsql-general mailing list (pgsql-general@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
|
