Обсуждение: WAL file naming after postmaster restart
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)
On Wed, Apr 12, 2006 at 11:05:52AM -0700, Sriram Dandapani wrote: > 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) I'm not sure why one should care about this, but AFAIK it's normal. -- Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461