From: | vishal saberwal <vishalsaberwal(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Rollback to Previous Version |
Date: | 2006-01-18 21:56:47 |
Message-ID: | 3e74dc250601181356o22e07e84uc27c55efe68fed0@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
hi all,
I am sure this problem has been thought of before but I haven't found any
good solution to this yet.
Problem:
We release schema with versions 1.0.0.1, 1.0.0.2, 1.0.0.3 for example.
Now client installs version 1.0.0.1 in year the 2001 and then upgrades to
version 1.0.0.2 in year the 2004 and then to version 1.0.0.3 in the year
2005. Client is not satisfied in 6 months and now wants to go back to
version 1.0.0.2.
In these 6 months he has a lot of data logged and configured (new and
modified from version 1.0.0.2) in the current schema.
What are the different/best ways/practices of rolling back to the previous
schema version?
What are the best practices to save/log the data being deleted and schema
changes being made to rollback to previous schema version?
What happens if the client wants to rollback to version 1.0.0.1 instead of
1.0.0.2 from version 1.0.0.3?
thanks,
vish
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2006-01-18 22:10:37 | Re: 32/64 architectures for backup/WALs |
Previous Message | Simon Riggs | 2006-01-18 21:52:04 | Re: No heap lookups on index |