postgresql

PostgreSQL – waiting for checkpoint to complete

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?

Solution

  • Call pg_basebackup with the option --checkpoint=fast to force a fast checkpoint rather than waiting for a spread one to complete.