Re: View restore error in 9.3-9.4 upgrade

On 2/23/15 7:55 PM, Stephen Frost wrote:
> David,
>
> * David Steele (david(at)pgmasters(dot)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 complete
>> the migration.
>
> Which pg_dumpall / pg_dump did you use? Generally speaking, you want to
> be using the pg_dumpall and pg_dump from the version of PostgreSQL which
> 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.

--
- David Steele
david(at)pgmasters(dot)net