We run a database server running PostgreSQL with database size of around 130GB growing at a rate of 500MB per day. We use HP Data Protector software to take backups of the database.
The issue here is that our database is on a GFS mounted partition and the current backup software license does not facilitate taking backups from GFS, NFS mounted partitions.
So, as a workaround, we planned to copy the database to a local partition using pg_dump
utility and take backups from the local partition using data protector software. But I am not sure whether we can take incremental backups using pg_dump
. Full backup everyday is not possible for us.
Please suggest steps for taking incremental backup of a PostgreSQL database.