pg_basebackup and checkpoints - Mailing list pgsql-general

From Alan Nilsson
Subject pg_basebackup and checkpoints
Date
Msg-id 5BEE067A-6EEA-4256-A4B0-42D56BA76999@apple.com
Whole thread Raw
Responses Re: pg_basebackup and checkpoints  (Magnus Hagander <magnus@hagander.net>)
List pgsql-general
I tried (and finally succeeded) to do a base backup tonight using pg_basebackup.  I was backing up a server that had no
activityon it.  The backup connected but no data was transferring, both ends sitting idle.   It finally occurred to me
totry a manual checkpoint and it then the backup took off and completed. 

According to 24.3 in the docs, pg_start_backup() performs a checkpoint.  So I was surpassed that using the pg_baseback
utilityI had to manual kick a checkpoint before the transfer would start.   

Is this correct behavior?

alan

fwiw, invocation:
pg_basebackup -P --xlog —host=XXXXX --pgdata=pgsql --user=replicate

pgsql-general by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: Re: Drop all overloads of a function without knowing parameter types
Next
From: Magnus Hagander
Date:
Subject: Re: pg_basebackup and checkpoints