Re: Application Dependency/Limitations of Postgres Version Upgrade

2018-03-10 Thread Félix GERZAGUET
On Sat, Mar 10, 2018 at 3:50 PM, Adrian Klaver wrote: > On 03/09/2018 10:49 PM, amitabh kumar wrote: > >> We have multiple servers with PG versions in 8.4, 9.2, 9.3, 9.4 and 9.5, >> that we want to upgrade to 9.6. We want to be sure that all applications >> will run smoothly after upgrade. >> > >

Re: Application Dependency/Limitations of Postgres Version Upgrade

2018-03-10 Thread Adrian Klaver
On 03/09/2018 10:49 PM, amitabh kumar wrote: Hi, I would like to know about application dependency of PostgreSQL version upgrade. We have multiple servers with PG versions in 8.4, 9.2, 9.3, 9.4 and 9.5, that we want to upgrade to 9.6. We want to be sure that all applications will run smooth

RE: Application Dependency/Limitations of Postgres Version Upgrade

2018-03-09 Thread Alvaro Aguayo Garcia-Rada
Hi. Based on my experience, you will probably have no problem when migrating applications from PG 9.x to 9.6. Same for 8.x to 9.6. I recently migrated an application installed on around 100 servers from 8.4 to 9.6, and the only problem I had was regarding database encoding, more specifically