Re: The sequence of WALs to be replayed - Mailing list pgsql-admin

From Albe Laurenz
Subject Re: The sequence of WALs to be replayed
Date
Msg-id A737B7A37273E048B164557ADEF4A58B50FA6FD3@ntex2010i.host.magwien.gv.at
Whole thread Raw
In response to The sequence of WALs to be replayed  (Shih Théo <galaxyshih@gmail.com>)
List pgsql-admin
Shih Théo wrote:
> I am using postgres incremental backup for quite a month. Every thing so far works great for me.
> However, one thing confuses me. That is the sequence of how WALs to be replayed.
> I know I can read this information when I turn on the log function but the sequence inside is not so
> clear especially when the amount of WALs is quite large.
> I need to know this information because I need to estimate how long does each restore take.
> Could somebody help me please.

The WAL segments are procesed in order, and that is the name of the file
interpreted as hex number (I'm ignoring the issue of timelines here).

You should be able to figure out the starting WAL segment from the
backup.label file in the backup.

Does that help?

Yours,
Laurenz Albe

pgsql-admin by date:

Previous
From: Jan Harasym
Date:
Subject: Re: pgAgent issue on redhat 6.5 for newbie
Next
From: "HEARNE, TIMOTHY S"
Date:
Subject: Need to calculate PostgreSQL memory usage