Re: pg_basebackup / recovery

From: Achilleas Mantzios - cloud <a(dot)mantzios(at)cloud(dot)gatewaynet(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: pg_basebackup / recovery
Date: 2023-04-12 10:45:56
Message-ID: 9f9aaa96-cd32-bbb9-ba15-d8685c9aeb08@cloud.gatewaynet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.
|

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John Howroyd 2023-04-12 10:50:21 Re: Guidance on INSERT RETURNING order
Previous Message David Rowley 2023-04-12 10:38:45 Re: parallel aggregation