PostgreSQL – waiting for checkpoint to complete

Question

When trying to perform pg_basebackup on a replica, I always get the following message:

postgres@db1:~/10$ pg_basebackup -h foo.bar.com -U repluser -D /var/lib/postgresql/10/main -v -P 
pg_basebackup: initiating base backup, waiting for checkpoint to complete

I've tried waiting, but nothing happens. Is it possible to speed up the process?

Answer 1

It's possible to force a checkpoint to complete. To do so, run CHECKPOINT; on the master server:

$ sudo su - postgres
$ psql
postgres=# CHECKPOINT;