Backup only changed databases

Поиск
Список
Период
Сортировка
От Benjamin Minshall
Тема Backup only changed databases
Дата
Msg-id 49E4DB96.3060100@intellicon.biz
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: Anderson Valadares
Дата:
Сообщение: High consumns memory
Следующее
От: Mark Dueck
Дата:
Сообщение: case insensitive like searches