Hello every one,
I am new to databases. I am using Postgres 8.2 (Migrating to 8.3.7 in few
days) on windows platform.
I had tried using Slony-I for replication and was not able to create a
cluster.
After struggling for some time i decide to implement a way around to take
differential backup. As the tables getting changed were very less.
Here is what i intend to do:
- Write a trigger for each of the tables in concern
- Some how write a function which can copy / execute the same query in
another temp Db on the same physical system (I have no idea how to do that)
- Take a backup of temp DB which will be the differential backup of DB (We
need to clear temp db after backup)
Am i going in the right direction?
Is there any way i can implement it.
Any help will be really of great help
Regards
Nishkarsh%-|
--
View this message in context: http://www.nabble.com/Trigger-Function-and-backup-tp24030638p24030638.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.