WAL file naming after postmaster restart

From: "Sriram Dandapani" <sdandapani(at)counterpane(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: WAL file naming after postmaster restart
Date: 2006-04-12 18:05:52
Message-ID: 6992E470F12A444BB787B5C937B9D4DF03EF4766@ca-mail1.cis.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi

I noticed something strange. When postgres crashed and restarted...the
archived WAL log file numbering did not take off from where it left
off..instead a new sequence was started (the new sequence was higher
than the last one before crashing)..Is this the expected behaviour on
postmaster crash and auto-recover. (I did not do a manual recovery with
the recover.conf)

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Chris Hoover 2006-04-12 20:53:40 Re: Autovacuum ideas
Previous Message Alvaro Herrera 2006-04-12 17:29:47 Re: savepoints