Обсуждение: postgres xlog crashes - recovery procedure

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

postgres xlog crashes - recovery procedure

От
Alexander Korobov
Дата:


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
Дата:
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
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110