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.

here you can find some tips and answers:
http://www.postgresql.org/docs/9.3/s...archiving.html
http://www.postgresql.org/docs/9.3/s...m-standby.html