On 8 November 2010 10:08, AI Rumman <rummandba@xxxxxxxxx> wrote:
I am going to migrate my produciton DB from postgresql 8.1 to 9.0.1.Anyone please tell me what the important things I have to look for this migration.Thanking you all.
Implicit casting might bite you since that was removed in 8.3.
Take a careful look at the migration notes for each release inbetween to see how they affect you:
http://www.postgresql.org/docs/9.0/static/release-8-2.html#AEN106653
http://www.postgresql.org/docs/9.0/static/release-8-3.html#AEN104194
http://www.postgresql.org/docs/9.0/static/release-8-4.html#AEN101283
http://www.postgresql.org/docs/9.0/static/release-9-0.html#AEN98988
--
Thom Brown
Twitter: @darkixion
IRC (freenode): dark_ixion
Registered Linux user: #516935
