Suppose I have a machine with 10GB
of free disk space, and I have a backup script of a postgresql
database, which when run, backs up locally and then copies to another remote server.
The problem is this, when the backup reaches a size equal to or greater than 10GB
, it will lack disk space and soon will give problem in everything that runs on that machine.
Question : Using pg_dump
and instead of backing up locally, already backing up by pointing to another machine with the -h
option, even if the total backup size is greater which% of%, will the buffer size be enough to not lock the machine in a matter of space?