Paul Tilles <paul(dot)tilles(at)noaa(dot)gov> 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 gotchas for each of those releases
(see the "Migration to Version X.X" heading in each major release).
http://www.postgresql.org/docs/9.2/static/release.html
regards, tom lane