Thread: migrate from 8.1 to 9.0
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.
On 8 November 2010 10:08, AI Rumman <rummandba@gmail.com> 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
2010/11/8 AI Rumman <rummandba@gmail.com>: > 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. You MUST read Releases Notes for each major version between to see what change and what may impact your application. -- Cédric Villemain 2ndQuadrant http://2ndQuadrant.fr/ PostgreSQL : Expertise, Formation et Support
On Mon, Nov 8, 2010 at 5:23 AM, Thom Brown <thom@linux.com> wrote: > Implicit casting might bite you since that was removed in 8.3. > Also if you use bytea fields to store binary data, the encoding format on return of the data is different. Make sure your client library handles that for you (or explicitly code for it). These are the two major issues we had to address between our 8.1->8.3->9.0 update over the last few years.
2010/11/8 Vick Khera <vivek@khera.org>: > On Mon, Nov 8, 2010 at 5:23 AM, Thom Brown <thom@linux.com> wrote: >> Implicit casting might bite you since that was removed in 8.3. >> > > Also if you use bytea fields to store binary data, the encoding format > on return of the data is different. Make sure your client library > handles that for you (or explicitly code for it). > > These are the two major issues we had to address between our > 8.1->8.3->9.0 update over the last few years. It is also possible to hit issues with plpgsql code quality. > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- Cédric Villemain 2ndQuadrant http://2ndQuadrant.fr/ PostgreSQL : Expertise, Formation et Support