Re: Tips for upgrading from 7.4 - Mailing list pgsql-general

From Vivek Khera
Subject Re: Tips for upgrading from 7.4
Date
Msg-id 43D8EA63-AF01-4E3A-ACBA-20D7A0A1FDBC@khera.org
Whole thread Raw
In response to Re: Tips for upgrading from 7.4  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Tips for upgrading from 7.4  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Jan 23, 2008, at 10:26 AM, Tom Lane wrote:

> Reading the release notes is good, but you really really should test
> the
> application(s) against a test 8.1 installation before you go live ...

be sure to run *every* query your system uses through 8.1.  the most
common problems you will run into are issues relating to using strings
as integers which tended to work in most cases in 7.x but not in 8.x.

the release notes cover such changes.  pay particular attention to
changes in auto typecasts.


pgsql-general by date:

Previous
From: Erik Jones
Date:
Subject: Re: pg_xlog and standby
Next
From: David Wall
Date:
Subject: Re: Postgresql + digital signature