Horton

Re: AW: AW: Very basic question about Archive logs

Laurenz Albe <laurenz.albe@cybertec.at>

View thread View on postgr.es
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: "Subramanian,Ramachandran" <ramachandran.subramanian@alte-leipziger.de>, "David G. Johnston" <david.g.johnston@gmail.com>
Cc: "pgsql-novice@lists.postgresql.org" <pgsql-novice@lists.postgresql.org>
Date: 2026-03-26T17:17:23Z
Lists: pgsql-novice 
On Thu, 2026-03-26 at 13:42 +0000, Subramanian,Ramachandran wrote:
> When I restore the base backup, from Monday 0100 Hours, Postgres will look
> at 0/53000028 and look for newer Logs beginning from this log file ...

Yes.

> ... in the Archivelog dir.

PostgreSQL knows no such directory.  It executes restore_command and expects
it to restore the desired WAL segment to pg_wal.

> Only in the archive log dir  because we would have over written the
> active log dir.

I don't understand that sentence.

> Postgres will rollforward till end of Logs OR a particular timestamp if one is specified.

Yes.

> Am I understanding this correctly?

I guess so.

Laurenz Albe