On Fri, 11 Nov 2005, Greg Troxel wrote:

> I'm not enough of a pg weenie to know the answers, and it wasn't clear
> from your note.  So unless migration from 7.3 to 7.4 is as simple as
>
> /etc/rc.d/pgsql stop
> pkg_delete postgresql\*
> cd /usr/pkgsrc/databases/postgresql-74 && make package clean
> /etc/rc.d/pgsql start

No, it's not.  In PostgreSQL, binary compatibility between objects/tables is
normally only across teeny versions (e.g., 7.3.1 to 7.3.2, but not 7.3.2 to
7.4.1).

In this specific case, it is documented that 7.3 tables must be dumped with
pg_dumpall and reloaded with psql/pg_restore upon upgrade to 7.4 or later.

-- 
-- Todd Vierling <tv@duh.org> <tv@pobox.com> <todd@vierling.name>