<!doctype html>
<html>
<head>
<meta charset="UTF-8">
</head>
<body>
<div style="font-size:14pt;font-family:arial,helvetica,sans-serif;color:#000000;" class="default-style">
Dear all,
<br>
</div>
<div style="font-size:14pt;font-family:arial,helvetica,sans-serif;color:#000000;" class="default-style">
<br>
</div>
<div style="font-size:14pt;font-family:arial,helvetica,sans-serif;color:#000000;" class="default-style">
I am running pg_basebackup with the following command on my Win10 machine:
</div>
<div style="font-size:14pt;font-family:arial,helvetica,sans-serif;color:#000000;" class="default-style">
<br>
</div>
<div style="font-size:14pt;font-family:arial,helvetica,sans-serif;color:#000000;" class="default-style">
"C:\Program Files\PostgreSQL\12\bin\pg_basebackup.exe" --pgdata=R:\PG_BASEBACKUP\20200304 \
</div>
<div style="font-size:14pt;font-family:arial,helvetica,sans-serif;color:#000000;" class="default-style">
--format=t \
</div>
<div style="font-size:14pt;font-family:arial,helvetica,sans-serif;color:#000000;" class="default-style">
--wal-method=stream \
</div>
<div style="font-size:14pt;font-family:arial,helvetica,sans-serif;color:#000000;" class="default-style">
--gzip \
</div>
<div style="font-size:14pt;font-family:arial,helvetica,sans-serif;color:#000000;" class="default-style">
--compress=6 \
</div>
<div style="font-size:14pt;font-family:arial,helvetica,sans-serif;color:#000000;" class="default-style">
--progress \
</div>
<div style="font-size:14pt;font-family:arial,helvetica,sans-serif;color:#000000;" class="default-style">
--verbose \
</div>
<div style="font-size:14pt;font-family:arial,helvetica,sans-serif;color:#000000;" class="default-style">
--status-interval=600 \
</div>
<div style="font-size:14pt;font-family:arial,helvetica,sans-serif;color:#000000;" class="default-style">
--username=postgres
</div>
<div style="font-size:14pt;font-family:arial,helvetica,sans-serif;color:#000000;" class="default-style">
<br>
</div>
<div style="font-size:14pt;font-family:arial,helvetica,sans-serif;color:#000000;" class="default-style">
With the following output:
<br>
</div>
<div style="font-size:14pt;font-family:arial,helvetica,sans-serif;color:#000000;" class="default-style">
<br>pg_basebackup: initiating base backup, waiting for checkpoint to complete
<br>pg_basebackup: checkpoint completed
<br>pg_basebackup: write-ahead log start point: 3A6/59000028 on timeline 1
<br>pg_basebackup: starting background WAL receiver
<br>pg_basebackup: created temporary replication slot "pg_basebackup_15532"
<br>3067352123/3067352123 kB (100%), 0/1 tablespace (..._BASEBACKUP\20200304/base.tar.gz)
</div>
<div style="font-size:14pt;font-family:arial,helvetica,sans-serif;color:#000000;" class="default-style">
<br>
</div>
<div style="font-size:14pt;font-family:arial,helvetica,sans-serif;color:#000000;" class="default-style">
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.
</div>
<div style="font-size:14pt;font-family:arial,helvetica,sans-serif;color:#000000;" class="default-style">
<br>
</div>
<div style="font-size:14pt;font-family:arial,helvetica,sans-serif;color:#000000;" class="default-style">
There is no additional activity on the server, just me, running pg_basebackup.
<br>
</div>
<div style="font-size:14pt;font-family:arial,helvetica,sans-serif;color:#000000;" class="default-style">
<br>
</div>
<div style="font-size:14pt;font-family:arial,helvetica,sans-serif;color:#000000;" class="default-style">
PostgreSQL version 12.1
<br>
</div>
<div style="font-size:14pt;font-family:arial,helvetica,sans-serif;color:#000000;" class="default-style">
<br>
</div>
<div style="font-size:14pt;font-family:arial,helvetica,sans-serif;color:#000000;" class="default-style">
Thanks!
<br>
</div>
<div style="font-size:14pt;font-family:arial,helvetica,sans-serif;color:#000000;" class="default-style">
Michael
<br>
</div>
</body>
</html>