postgrespro
Using pg_probackup do incremetal backup is always stuck，How can I fix this problem ?
When I using pg_probackup tool to backs up a database( The database capacity is about 600GB）, the full backup usually successful at one time , but the incremental backup is always stuck.，which Keep running for several days, until I manually kill the relevant process。 full backup command: pg_probackup backup -B /paic/pgbackup/advicepg/pgrman -b full --progress --instance=advicepg --compress-algorithm=zlib incremental backup command: pg_probackup backup -B /paic/pgbackup/advicepg/pgrman -b page --progress --instance=advicepg --compress-algorithm=zlib
So can you tell me how to troubleshoot the problem that incremental backup always fails，and I'm looking forward to your reply,Thanks for your attension！
[postgres@CQ2-BLM9600040 ~]$ ps -ef|grep pg_probackup postgres 193667 193012 0 10:15 pts/4 00:00:00 grep --color=auto pg_probackup postgres 268042 268030 99 03:05 ? 07:08:35 pg_probackup backup -B /paic/pgbackup/advicepg/pgrman -b page --progress --instance=advicepg --compress-algorithm=zlib --compress-level=1 -j 6 --log-level-file=verbose [postgres@CQ2-BLM9600040 ~]$
@cartooku Have you configured WAL archiving?
Is there any error in logs?
on database server:
archive_command = '"install_dir/pg_probackup" archive-push -B "backup_dir" --instance instance_name --wal-file-name=%f [remote_options]'
Hello! Can you provide the available output of the process before it is getting stuck?
