Incremental backup of PostgreSQL database
We run a database server running PostgreSQL with database size of around 130 GB growing at a rate of 500MB per day . We use HP Data Protector software to take backup 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 backup 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 backup from the local partition using data protector software. But I am not sure whether we can take incremental backup using pg_dump . Full backup everyday is not possible for us.
Please suggest steps for taking incremental backup from PostgreSQL database.
|