Re: WAL files not following sequence

From: Amit Langote <amitlangote09(at)gmail(dot)com>
To: German Becker <german(dot)becker(at)gmail(dot)com>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: WAL files not following sequence
Date: 2013-05-22 00:19:10
Message-ID: CA+HiwqEm_ORhuAh8_9qyQNWyMxOfmPnstZhnju3DOv8jJxrPRw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Wed, May 22, 2013 at 3:28 AM, German Becker <german(dot)becker(at)gmail(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Dann Corbit 2013-05-22 00:21:54 Re: [GENERAL] ODBC constructs
Previous Message Kasia Tuszynska 2013-05-21 23:07:38 Re: pg_restore