postgres xlog crashes - recovery procedure

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: Raw Message | Whole Thread | 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.

Responses

Browse pgsql-admin by date

  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