postgresql recovery after pg_resetxlog
От | Changqing Zhou |
---|---|
Тема | postgresql recovery after pg_resetxlog |
Дата | |
Msg-id | Pine.GSO.4.58.0509221652480.3326@caesar.cs.umn.edu обсуждение исходный текст |
Ответ на | Re: Postgres 7.4.5 fails with Cygwin 1.5.18-1 (core dump) (Samik Raychaudhuri <samik@freeshell.org>) |
Список | pgsql-cygwin |
I run postgresql 7.4 on cygwin. After my database refused to start (after a crash), I executed pg_resetxlog and tried to restart the database: /usr/local/pgsql/bin/postmaster -d 5 -D /usr/local/pgsql/place After I issued this command, the database has been trying to recover itself, which is nice. The problem is that it has been recovering for almost 10 hours now, and it is still trying to go through all the PIDs. Can anybody tell me: is there a log file that tells me how many more PIDs need to be processed? I am just concerned how long this is going to take. I have a full back up of the data. The runtime log is something like: DEBUG: reaping dead processes DEBUG: child process (PID 5504) exited with exit code 0 DEBUG: proc_exit(0) DEBUG: shmem_exit(0) DEBUG: exit(0) DEBUG: reaping dead processes DEBUG: child process (PID 4652) exited with exit code 0 DEBUG: proc_exit(0) DEBUG: shmem_exit(0) DEBUG: exit(0) DEBUG: reaping dead processes DEBUG: child process (PID 6044) exited with exit code 0 Thanks, Changqing Zhou University of Minnesota
В списке pgsql-cygwin по дате отправления: