[HACKERS] question: data file update when pg_basebackup in progress - Mailing list pgsql-hackers

From Rui Hai Jiang
Subject [HACKERS] question: data file update when pg_basebackup in progress
Date
Msg-id PS1PR02MB15473B7387683C98F2D9909EA01E0@PS1PR02MB1547.apcprd02.prod.outlook.com
Whole thread Raw
Responses Re: [HACKERS] question: data file update when pg_basebackup in progress  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-hackers

Hello,
I'm checking how the pg_basebackup works and I got a question(maybe there are no such issues):

When pg_basebackup is launched, a checkpoint is created first, then all files are transferred to the  pg_basebackup client.  Is it possible that a data page(say page-N) in a data file is changed after the checkpoint and before the pg_basebackup is finished?

If this happens,  is it possible that only part of the changed page be transferred to the pg_basebackup client?  i.e.  the pg_basebackup client gets page-N with part of the old content and part of the new content. How does postgreSQL handle this kind of data page?

Thanks,
Rui Hai

pgsql-hackers by date:

Previous
From: Fujii Masao
Date:
Subject: Re: [HACKERS] Quorum commit for multiple synchronous replication.
Next
From: Serge Rielau
Date:
Subject: Re: [HACKERS] Cached plans and statement generalization