postgres xlog crashes - recovery procedure

Поиск
Список
Период
Сортировка
Искать

postgres xlog crashes - recovery procedure

От:
Alexander Korobov <akorobov@cisco.com>
Дата:



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.

Re: postgres xlog crashes - recovery procedure

От:
Andrew Sullivan <andrew@libertyrms.info>
Дата:
On Tue, Oct 29, 2002 at 01:47:40PM -0500, Alexander Korobov wrote:
> 
> I'm aware of contrib/pg_resetxlog but this does not seem to be reliable tool.

It's as reliable as it can be, as far as I know.  There is the
potential for data loss, but that's the problem with having lost your
WAL.

> Are there any postgres specific recovery procedures and /or documentation on how 
> to prevent such situations?

The recovery in this case is pg_resetxlog.  As for prevention, it
depends on what happened.  Any ideas?

A

-- 
----
Andrew Sullivan                         204-4141 Yonge Street
Liberty RMS                           Toronto, Ontario Canada
                              M2P 2A8
                                         +1 416 646 3304 x110

FAQ