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
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
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?
>>
>>
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
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