pg_basebackup progress at 100% for many hours, but still writing data to disk

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

pg_basebackup progress at 100% for many hours, but still writing data to disk

Michael Jendryke
Dear all,

I am running pg_basebackup with the following command on my Win10 machine:

"C:\Program Files\PostgreSQL\12\bin\pg_basebackup.exe" --pgdata=R:\PG_BASEBACKUP\20200304 \
--format=t \
--wal-method=stream \
--gzip \
--compress=6 \
--progress \
--verbose \
--status-interval=600 \
--username=postgres

With the following output:

pg_basebackup: initiating base backup, waiting for checkpoint to complete
pg_basebackup: checkpoint completed
pg_basebackup: write-ahead log start point: 3A6/59000028 on timeline 1
pg_basebackup: starting background WAL receiver
pg_basebackup: created temporary replication slot "pg_basebackup_15532"
3067352123/3067352123 kB (100%), 0/1 tablespace (..._BASEBACKUP\20200304/base.tar.gz)

As you can see, I turned on --progress to see when my backup is done. However 100% is reached for many hours already and the kB count keeps on increasing. I can see that data is being written to disk and that base.tar.gz gets larger and larger. The initial number that pg_basebackup presented to be 100% was ~2.2 TB, which I assume is wrong, as the datadir is ~3.5TB.

There is no additional activity on the server, just me, running pg_basebackup.

PostgreSQL version 12.1

Thanks!
Michael