Re: View restore error in 9.3-9.4 upgrade

On 2/23/15 7:55 PM, Stephen Frost wrote:
> David,
>=20
> * David Steele (david@pgmasters.net) wrote:
>> I upgraded from 9.3 to 9.4 last week using pg_dumpall and psql to dump=

>> and import the database.  I got an error during the creation of one of=

>> the views and ended up having to patch the pl/pgsql manually to comple=
te
>> the migration.
>=20
> Which pg_dumpall / pg_dump did you use?  Generally speaking, you want t=
o
> be using the pg_dumpall and pg_dump from the version of PostgreSQL whic=
h
> you are upgrading *to*.  In this case, you'd want to use the 9.4
> pg_dumpall and pg_dump.

During the actual migration I used the 9.4 pg_dump, but for my tests I
used 9.3.  I just redid the tests exporting with 9.4 and it failed in
the same way.

--=20
- David Steele
david@pgmasters.net