Re: [GENERAL] Guidelines for upgrading from pgsql7.4.xxx server to

2006-03-29 Thread Scott Marlowe
On Tue, 2006-03-28 at 20:53, Luki Rustianto wrote: > Hi All, > > All of our application now runs on postgresql7.4.xxx servers, I never > tried it on version 8.xxx > > I wonder if there are any guidelines / step by step / special > considerations whether it applies to database structure or the > a

Re: [GENERAL] Guidelines for upgrading from pgsql7.4.xxx server to pgsql8.xxx server

2006-03-29 Thread Gregory S. Williamson
As others have pointed out, OID dependant tables may need special attention. We recently upgraded from 7.4 to 8.1.x and found some issues with encoding -- 8.1 defaulted to a different encoding and we had some data that was invalid; we manually fixed the old data before retrying the export. Make

Re: [GENERAL] Guidelines for upgrading from pgsql7.4.xxx server to

2006-03-28 Thread Tom Lane
Chris Travers <[EMAIL PROTECTED]> writes: > Luki Rustianto wrote: >> I wonder if there are any guidelines / step by step / special >> considerations whether it applies to database structure or the >> application it self if we want to upgrade to version 8.xxx ? > Depends on if your app depends on t

Re: [GENERAL] Guidelines for upgrading from pgsql7.4.xxx server to

2006-03-28 Thread Chris Travers
Luki Rustianto wrote: Hi All, All of our application now runs on postgresql7.4.xxx servers, I never tried it on version 8.xxx I wonder if there are any guidelines / step by step / special considerations whether it applies to database structure or the application it self if we want to upgrade t