Hi,
We have scheduled postgres full backup on centos 7 machine. DB size is
around 66 GB. We observed while backup is running, postmaster CPU % reaches
to 90 - 100%,which results very strange behavior: that we are not able to
perform any DDL and DML on to the database during the time.
Please sugges
Hi,
Here , we have first tried with .BAK backups. For, 43GB database-> the
backup size was ~86GB.
Then, I configured backup with .sql file. Here it was ~70GB for the same
database size.
Next, now our database size keeps increasing. As well as backup size is
also increasing. Now, backup size is