Recovery when old WAL segment has been overwritten?

From: John Barham <jbarham(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Recovery when old WAL segment has been overwritten?
Date: 2005-06-07 15:42:40
Message-ID: 4f34febc0506070842680f34a0@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi folks,

Running 8.0.1 on Linux I got this in my log yesterday morning:

LOG: unexpected EOF on client connection
LOG: unexpected EOF on client connection
LOG: archived transaction log file "000000010000000A0000003F"
LOG: server process (PID 15318) was terminated by signal 9
LOG: terminating any other active server processes
WARNING: terminating connection because of crash of another server process
DETAIL: The postmaster has commanded this server process to roll back
the current transaction and exit, because another server process
exited abnormally and possibly corrupted shared memory.

However, very soon after this happened the server archived the segment
0000000100000008000000C2 which had originally been archived on May 28,
so I have only been able to "recover" the database to May 28 as my
most recent base backup was from May 26. How can I recover the data
that was written between May 28 and yesterday morning?

John Barham

Browse pgsql-general by date

  From Date Subject
Next Message Dianne Yumul 2005-06-07 15:44:27 Re: Postgresql fails to start?
Previous Message Thomas Radnetter 2005-06-07 15:40:08 how to loop until eof in a cursor with pgsql