question: data file update when pg_basebackup in progress

From: Rui Hai Jiang <ruihaijiang(at)msn(dot)com>
To: "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: question: data file update when pg_basebackup in progress
Date: 2017-04-25 16:08:43
Message-ID: PS1PR02MB15473B7387683C98F2D9909EA01E0@PS1PR02MB1547.apcprd02.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Serge Rielau 2017-04-25 16:12:41 Re: Cached plans and statement generalization
Previous Message Fujii Masao 2017-04-25 16:08:13 Re: Quorum commit for multiple synchronous replication.