Re: pg_basebackup / recovery - Mailing list pgsql-general

From Achilleas Mantzios - cloud
Subject Re: pg_basebackup / recovery
Date
Msg-id 9f9aaa96-cd32-bbb9-ba15-d8685c9aeb08@cloud.gatewaynet.com
Whole thread Raw
In response to pg_basebackup / recovery  (Fabrice Chapuis <fabrice636861@gmail.com>)
Responses Re: pg_basebackup / recovery
List pgsql-general

On 4/12/23 12:32, Fabrice Chapuis wrote:

During recovery process of a self contained backup, how postgres know to stop reading wal when consistency is reached?


Because it knows the full packup info. It will observe the

STOP WAL LOCATION: 3BC7/4B000130 (file 0000000200003BC70000004B)

inside the backup file

 It's a full contained backup because you haven't called with the -X method none , and it doesn't get into standby because you haven't called with --write-recovery-conf !

I believe by default it will do what you meant that you want.

pgsql-general by date:

Previous
From: David Rowley
Date:
Subject: Re: parallel aggregation
Next
From: John Howroyd
Date:
Subject: Re: Guidance on INSERT RETURNING order