Fwd: [GENERAL] upgrading from V8.3.4 to V9.2.4

2013-04-19 Thread Ian Harding
Forgot to include the list! Sorry! If you have a non-standard socket file location pg_upgrade will not work for this upgrade. On Fri, Apr 5, 2013 at 9:37 AM, Leonardo Carneiro wrote: > Beside all notes, i recommend you to use pg_upgrade, to avoid a complete > backup/restore in your transition.

Re: [GENERAL] upgrading from V8.3.4 to V9.2.4

2013-04-05 Thread Leonardo Carneiro
Beside all notes, i recommend you to use pg_upgrade, to avoid a complete backup/restore in your transition. http://www.postgresql.org/docs/9.2/static/pgupgrade.html On Fri, Apr 5, 2013 at 1:30 PM, Kevin Grittner wrote: > Robert Treat wrote: > > > Yeah, there were also some subtle breakage aro

Re: [GENERAL] upgrading from V8.3.4 to V9.2.4

2013-04-05 Thread Kevin Grittner
Robert Treat wrote: > Yeah, there were also some subtle breakage around keywords used > as variable naming when plpgsql was port to use the core lexer. One more: from a Java client access to bytea columns will break if you don't also use the latest JDBC driver jar. -- Kevin Grittner EnterpriseD

Re: [GENERAL] upgrading from V8.3.4 to V9.2.4

2013-04-05 Thread Robert Treat
On Wed, Apr 3, 2013 at 10:02 PM, Adrian Klaver wrote: > On 04/03/2013 10:14 AM, Paul Tilles wrote: >> >> We are going to be upgrading our postgres version from 8.3.4 to 9.2.4 in >> the near future. >> >> Can anyone give me a short list of "gotchas" concerning problems we >> might step into? >> >>

Re: [GENERAL] upgrading from V8.3.4 to V9.2.4

2013-04-03 Thread Adrian Klaver
On 04/03/2013 10:14 AM, Paul Tilles wrote: We are going to be upgrading our postgres version from 8.3.4 to 9.2.4 in the near future. Can anyone give me a short list of "gotchas" concerning problems we might step into? We have a number of functions written in PL/pgSQL. Will they work in 9.2.4 w

Re: [GENERAL] upgrading from V8.3.4 to V9.2.4

2013-04-03 Thread Tom Lane
Paul Tilles writes: > We are going to be upgrading our postgres version from 8.3.4 to 9.2.4 in > the near future. > Can anyone give me a short list of "gotchas" concerning problems we > might step into? You'll need to review the release notes for 8.4, 9.0, 9.1, and 9.2 to see the compatibility

[GENERAL] upgrading from V8.3.4 to V9.2.4

2013-04-03 Thread Paul Tilles
We are going to be upgrading our postgres version from 8.3.4 to 9.2.4 in the near future. Can anyone give me a short list of "gotchas" concerning problems we might step into? We have a number of functions written in PL/pgSQL. Will they work in 9.2.4 without modification? Thanks in advance