| From: | Alexander Korobov <akorobov(at)cisco(dot)com> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | postgres xlog crashes - recovery procedure |
| Date: | 2002-10-29 18:47:40 |
| Message-ID: | 20021029184740.GW1644@blackbox.cisco.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Hello,
I'm trying to recover database(after a crash). postgres is failing to
start complaining on missing transaction log file :
--------------------------------------------------------------------------------
2002-10-22 14:53:17 [2247] DEBUG: database system was interrupted at 2002-10-17 23:24:45 PST
2002-10-22 14:53:17 [2247] DEBUG: ReadRecord: out-of-sequence SUI 220 (after 221) in log file 4, segment 111,
offset 450560
2002-10-22 14:53:17 [2247] DEBUG: invalid primary checkpoint record
2002-10-22 14:53:17 [2247] DEBUG: open of /pg_xlog/000000040000006E (log file 4, segment 110) faile
d: No such file or directory
2002-10-22 14:53:17 [2247] DEBUG: invalid secondary checkpoint record
2002-10-22 14:53:17 [2247] FATAL 2: unable to locate a valid checkpoint record
2002-10-22 14:53:17 [2247] DEBUG: proc_exit(2)
2002-10-22 14:53:17 [2247] DEBUG: shmem_exit(2)
2002-10-22 14:53:17 [2247] DEBUG: exit(2)
2002-10-22 14:53:17 [2244] DEBUG: reaping dead processes
2002-10-22 14:53:17 [2244] DEBUG: startup process (pid 2247) exited with exit code 2
2002-10-22 14:53:17 [2244] DEBUG: aborting startup due to startup process failure
2002-10-22 14:53:17 [2244] DEBUG: proc_exit(1)
2002-10-22 14:53:17 [2244] DEBUG: shmem_exit(1)
2002-10-22 14:53:17 [2244] DEBUG: exit(1)
--------------------------------------------------------------------------------
I'm aware of contrib/pg_resetxlog but this does not seem to be reliable tool.
Are there any postgres specific recovery procedures and /or documentation on how
to prevent such situations?
Thanks,
ak.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Devinder K Rajput | 2002-10-29 21:03:44 | ODBC error |
| Previous Message | Bruce Momjian | 2002-10-29 18:24:37 | Re: pg_upgrade problems |