Re: WAL files not following sequence - Mailing list pgsql-admin

From Amit Langote
Subject Re: WAL files not following sequence
Date
Msg-id CA+HiwqEm_ORhuAh8_9qyQNWyMxOfmPnstZhnju3DOv8jJxrPRw@mail.gmail.com
Whole thread Raw
In response to WAL files not following sequence  (German Becker <german.becker@gmail.com>)
Responses Re: WAL files not following sequence  (German Becker <german.becker@gmail.com>)
List pgsql-admin
On Wed, May 22, 2013 at 3:28 AM, German Becker <german.becker@gmail.com> wrote:
> 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?

can you show the output of "ls -l " for your pg_xlog?


--
Amit Langote


pgsql-admin by date:

Previous
From: Kasia Tuszynska
Date:
Subject: Re: pg_restore
Next
From: Albe Laurenz
Date:
Subject: Re: Question about maintenance_work_mem and shared_buffer