Home > mailing lists

Re: Unexpected trouble from pg_basebackup - Mailing list pgsql-general

From	Magnus Hagander
Subject	Re: Unexpected trouble from pg_basebackup
Date	October 4, 2016 23:49:50
Msg-id	CABUevEyFEZSPbEAX8a5rZx=Lrmb_hTYfcXiibBjznJQBGfujkQ@mail.gmail.com Whole thread Raw
In response to	Re: Unexpected trouble from pg_basebackup (otheus uibk <otheus.uibk@gmail.com>)
List	pgsql-general

On Tue, Oct 4, 2016 at 10:42 PM, otheus uibk <otheus.uibk@gmail.com> wrote:

After a 3 to 4 minute delay, pg_basebackup started doing it's thing and finished within a few minutes. So now the question is: why the startup delay?

Sounds to me like it's doing a CHECKPOINT with spreading, which make it take time. Try with "-c fast" and see if the problem goes away.

From: otheus uibk
Date: 04 October 2016, 23:43:24
Subject: Re: Unexpected trouble from pg_basebackup

From: Kenneth Marshall
Date: 04 October 2016, 23:56:54
Subject: Re: postgresql 9.5 upsert issue with nulls