Backup only changed databases - Mailing list pgsql-admin

From Benjamin Minshall
Subject Backup only changed databases
Date
Msg-id 49E4DB96.3060100@intellicon.biz
Whole thread Raw
List pgsql-admin
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>

pgsql-admin by date:

Previous
From: Anderson Valadares
Date:
Subject: High consumns memory
Next
From: Mark Dueck
Date:
Subject: case insensitive like searches