WAL files not following sequence

From: German Becker <german(dot)becker(at)gmail(dot)com>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: WAL files not following sequence
Date: 2013-05-21 18:28:22
Message-ID: CALyjCLsufkaPp=xDaWXmo-oymNhcneW216Uf_to8dCoy27kVQA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi all,

I have noticed a strange behaviour regarding WAL sequence numbers. I am
populating a new DB with old data. To populate the largest part of the data
I use wal_level=minimal and archive_mode=off. Then I stop the database and
set wal_level=hotstandby and archive_mode=on. After I do that, I notice
that the WAL sequence number "rewinds" a little bit, overlaping with the
old ones... Is this normal?

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Dev Kumkar 2013-05-21 18:58:48 Re: [GENERAL] ODBC constructs
Previous Message Rodrigo Barboza 2013-05-21 16:45:49 Re: Question about maintenance_work_mem and shared_buffer