DB & Log Files removed...
От | Lynn.Tilby@asu.edu |
---|---|
Тема | DB & Log Files removed... |
Дата | |
Msg-id | 1071790487.3fe23997ee866@webmail.asu.edu обсуждение исходный текст |
Ответы |
Re: DB & Log Files removed...
|
Список | pgsql-general |
I am running an experimental system, my disk filled up when running a table build from a query. I mistakenly blew away the files in ../pgsql/data/base/18773 & ../pgsql/data/pg_xlog with NO BU! Recover is only bringing back 8 of about 90 files. I can rebuild the DB from scratch relatively easily... I was going to try and just do a drop database but I get this when trying to bring up the postmaster. [postgres@polaris pgsql]$ postmaster DEBUG: database system shutdown was interrupted at 2003-12-17 12:32:40 MST DEBUG: open(logfile 6 seg 134) failed: No such file or directory DEBUG: Invalid primary checkPoint record DEBUG: open(logfile 6 seg 134) failed: No such file or directory DEBUG: Invalid secondary checkPoint record FATAL 2: Unable to locate a valid CheckPoint record postmaster: Startup proc 18179 exited with status 512 - abort Where is the postmaster getting the 'logfile 6 seg 134' from? Are there any files I can edit to solve this problem, or perhaps something else I can do? I am running RH 6.2 with pgsql 7.1.3 I thought of just reinstalling 7.1.3 for the time being but I only see 7.1.3 for RH 7.1 available on the download site. If I am unable to just rebuild the DB is there an archive somewhere that I can download 7.1.3 for RH6.2 from or... would I be OK with the RH7.1 version on an RH6.2 box? My gut feel is that this would not work. (... i know... it's time to upgrade) Thanks, Lynn
В списке pgsql-general по дате отправления: