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