Re: AW: AW: Very basic question about Archive logs - Mailing list pgsql-novice

From Laurenz Albe
Subject Re: AW: AW: Very basic question about Archive logs
Date
Msg-id 2da4630ad323530f46b9ad44bfcd90830c390dfb.camel@cybertec.at
Whole thread Raw
In response to AW: AW: Very basic question about Archive logs  ("Subramanian,Ramachandran" <ramachandran.subramanian@alte-leipziger.de>)
List 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



pgsql-novice by date:

Previous
From: "Subramanian,Ramachandran"
Date:
Subject: AW: AW: Very basic question about Archive logs
Next
From: Ibrahim Shaame
Date:
Subject: Adding column in a recursive query