Thread: Backup only changed databases

Backup only changed databases

From
Benjamin Minshall
Date:
Hello,

I am curious if there is a way to know which databases have changed (any write transaction) since a given timestamp?  I
usepg_dump nightly to backup several databases within the cluster, but I would like to only pg_dump those databases
whichhave actually changed during the day.  Is there a solution to this?  I have to use pg_dump, because I need to be
ableto selectively restore databases without disrupting the rest of the cluster.  I'm running postgreSQL 8.3.7 

Thank you.

--
Benjamin Minshall <minshall@intellicon.biz>