Hello, I am curious if there is a way to know which databases have changed (any write transaction) since a given timestamp? I use pg_dump nightly to backup several databases within the cluster, but I would like to only pg_dump those databases which have actually changed during the day. Is there a solution to this? I have to use pg_dump, because I need to be able to selectively restore databases without disrupting the rest of the cluster. I'm running postgreSQL 8.3.7
Thank you. -- Benjamin Minshall <[email protected]> -- Sent via pgsql-admin mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
