We have a customer with database size around 1TB who wants take dump based backed. We are planning to use FIFO file to redirect the output of 'pg_dump -FC' . Our backup process will read the data from FIFO file and write to storage media.
On smaller databases we tested this and we didn't face any issues.
Just wanted to confirm if we can safely redirect 'pg_dump -FC' to FIFO file without any possible dump corruption.
