Re: [GENERAL] Postgres 8.0 upgrade to 9.0

2011-08-02 Thread Ognjen Blagojevic
Hi Atul, On 1.8.2011 16:12, Atul Goel wrote: We are planning to upgrade a postgres 8.0 database to postgres 9.0 (Actually already done in Dev). The application is J2EE application with Hibernate. My question are 1)Is there a list of things that needs to be taken care while upgrading(known issue

Re: [GENERAL] Postgres 8.0 upgrade to 9.0

2011-08-01 Thread Scott Marlowe
On Mon, Aug 1, 2011 at 8:12 AM, Atul Goel wrote: > Hi Forum, > > We are planning to upgrade a postgres 8.0 database to postgres 9.0 (Actually > already done in Dev). The application is J2EE application with Hibernate. My > question are > > 1)  Is there a list of things that needs to be taken c

Re: [GENERAL] Postgres 8.0 upgrade to 9.0

2011-08-01 Thread Craig Ringer
On 1/08/2011 11:07 PM, Atul Goel wrote: Hi Forum, We are planning to upgrade a postgres 8.0 database to postgres 9.0 (Actually already done in Dev). The application is J2EE application with Hibernate. My question are 1)Is there a list of things that needs to be taken care while upgrading(known

Re: [GENERAL] Postgres 8.0 upgrade to 9.0

2011-08-01 Thread Hannes Erven
Atul, > 2) Do I need to upgrade JDBC driver when I upgrade to postgres9.0. Yes, at least if you use BLOB types. The 9.0 server sends them in a format former JDBC drivers cannot understand: http://www.postgresql.org/docs/9.0/static/runtime-config-client.html#GUC-BYTEA-OUTPUT Other than that

Re: [GENERAL] Postgres 8.0 upgrade to 9.0

2011-08-01 Thread John Cheng
I am planning on bringing our 8.3 installation up to 9.0.4. First I upgraded the jdbc driver on our staging environment, after 1 month on staging, we tested with the 9.0 driver on production. The actual database upgrade will be more complicated, and we are going to simulate an upgrade on a non-prod

Re: [GENERAL] Postgres 8.0 upgrade to 9.0

2011-08-01 Thread Jaime Casanova
On Mon, Aug 1, 2011 at 9:12 AM, Atul Goel wrote: > Hi Forum, > > We are planning to upgrade a postgres 8.0 database to postgres 9.0 (Actually > already done in Dev). consider that 9.0 is not the next version after 8.0, there were 4 more (8.1, 8.2, 8.3 and 8.4) and at least for changing from 8.2 t

[GENERAL] Postgres 8.0 upgrade to 9.0

2011-08-01 Thread Atul Goel
Hi Forum, We are planning to upgrade a postgres 8.0 database to postgres 9.0 (Actually already done in Dev). The application is J2EE application with Hibernate. My question are 1) Is there a list of things that needs to be taken care while upgrading(known issues). 2) Do I need to u

[GENERAL] Postgres 8.0 upgrade to 9.0

2011-08-01 Thread Atul Goel
Hi Forum, We are planning to upgrade a postgres 8.0 database to postgres 9.0 (Actually already done in Dev). The application is J2EE application with Hibernate. My question are 1) Is there a list of things that needs to be taken care while upgrading(known issues). 2) Do I need to up