this is 7.3.3 (PGDG rpm's) on red hat 7.2:
i had a lot of debugging enabled. i went to create an index, and pgsql
dumped on me. i tried restarting several times - no luck.
starting postgresql gives
LOG: database system shutdown was interrupted at 2004-07-16 01:11:56 EDT
LOG: checkpoint record
lists <[EMAIL PROTECTED]> writes:
> Alvaro Herrera wrote:
>>> this is 7.3.3 (PGDG rpm's) on red hat 7.2
>>
>> Get 7.3.6 and try again. IIRC this is a known bug that was repaired in
>> 7.3.4.
> to get the data back, is it a matter of just upgrading and starting the
> db (ie will it perform recov
On Fri, Jul 16, 2004 at 01:55:13AM -0400, lists wrote:
> thank you for replying.
>
> Alvaro Herrera wrote:
> >>LOG: ReadRecord: unexpected pageaddr 0/33A4000 in log file 0, segment
> >>5, offset 3817472
> >>LOG: redo is not required
> >>PANIC: XLogWrite: write request 0/53A4000 is past end of
On Fri, Jul 16, 2004 at 02:09:33PM +0800, Christopher Kings-Lynne wrote:
> >>LOG: ReadRecord: unexpected pageaddr 0/33A4000 in log file 0, segment
> >>5, offset 3817472
> >>LOG: redo is not required
> >>PANIC: XLogWrite: write request 0/53A4000 is past end of log 0/53A4000
> >>LOG: startup pro
>>LOG: ReadRecord: unexpected pageaddr 0/33A4000 in log file 0, segment
5, offset 3817472
LOG: redo is not required
PANIC: XLogWrite: write request 0/53A4000 is past end of log 0/53A4000
LOG: startup process (pid 16068) was terminated by signal 6
LOG: aborting startup due to startup process f
thank you for replying.
Alvaro Herrera wrote:
LOG: ReadRecord: unexpected pageaddr 0/33A4000 in log file 0, segment
5, offset 3817472
LOG: redo is not required
PANIC: XLogWrite: write request 0/53A4000 is past end of log 0/53A4000
LOG: startup process (pid 16068) was terminated by signal 6
LOG
On Fri, Jul 16, 2004 at 01:32:01AM -0400, lists wrote:
> LOG: ReadRecord: unexpected pageaddr 0/33A4000 in log file 0, segment
> 5, offset 3817472
> LOG: redo is not required
> PANIC: XLogWrite: write request 0/53A4000 is past end of log 0/53A4000
> LOG: startup process (pid 16068) was termin
i had a lot of debugging enabled. i went to create an index, and pgsql
dumped on me. i tried restarting several times - no luck.
starting postgresql gives:
LOG: database system shutdown was interrupted at 2004-07-16 01:11:56 EDT
LOG: checkpoint record is at 0/53A3FC0
LOG: redo record is at 0