could not open file "/var/lib/pgsql/data/pg_xlog/0000000000000001"
| От | Barry Clearwater | 
|---|---|
| Тема | could not open file "/var/lib/pgsql/data/pg_xlog/0000000000000001" | 
| Дата | |
| Msg-id | 1087202682.5267.94.camel@localhost обсуждение исходный текст | 
| Ответы | Re: could not open file "/var/lib/pgsql/data/pg_xlog/0000000000000001" Re: could not open file "/var/lib/pgsql/data/pg_xlog/0000000000000001" | 
| Список | pgsql-admin | 
Having sucessfully crashed sql ledger and desperate to see if I can start it again, I read a posting by Lamar Owen which helped me get a meaningful output to debug. Problem started when I inadvertantly started the computer at a date in the future. Now I found I have deleted an important file (0000000000000001) -not a very useful name, I assumed it was a log file. bash-2.05b$ LOG: database system was interrupted at 2004-07-23 00:40:11 NZST LOG: could not open file "/var/lib/pgsql/data/pg_xlog/0000000000000001" (log file 0, segment 1): No such file or directory LOG: invalid primary checkpoint record LOG: could not open file "/var/lib/pgsql/data/pg_xlog/0000000000000001" (log file 0, segment 1): No such file or directory LOG: invalid secondary checkpoint record PANIC: could not locate a valid checkpoint record LOG: startup process (PID 9970) was terminated by signal 6 LOG: aborting startup due to startup process failure Is there any way I can recreate a checkpoint record or resurrect any data from postgresql. How important was the 0000000000000001 file ? Thank you Barry Clearwater
В списке pgsql-admin по дате отправления: