WAL file naming after postmaster restart - Mailing list pgsql-admin

From Sriram Dandapani
Subject WAL file naming after postmaster restart
Date
Msg-id 6992E470F12A444BB787B5C937B9D4DF03EF4766@ca-mail1.cis.local
Whole thread Raw
Responses Re: WAL file naming after postmaster restart  ("Jim C. Nasby" <jnasby@pervasive.com>)
List 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)

pgsql-admin by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: savepoints
Next
From: "Chris Hoover"
Date:
Subject: Re: Autovacuum ideas