Re: PG_UPGRADE FAILED FROM 9.5 to 11*

On Thu, Jun 18, 2020 at 06:42:11PM +0000, Jaspreet Singh wrote:
> Hi Team
> 
> We are upgrading our 9.5 postgres database to 11* version and it failed with
> below error . please help .
> 
>  
> 
> /usr/pgsql-11/bin/pg_upgrade  -b /usr/pgsql-9.5/bin -B /usr/pgsql-11/bin -d /
> pgdata/data -D /var/lib/pgsql/11/data/
> 
>  
> 
> pg_restore: [archiver (db)] Error while PROCESSING TOC:
> 
> pg_restore: [archiver (db)] Error from TOC entry 185; 1259 1183792 VIEW
> pg_stat_activity postgres
> 
> pg_restore: [archiver (db)] could not execute query: ERROR:  column
> pg_stat_activity.waiting does not exist
> 
> LINE 27:     "pg_stat_activity"."waiting",
> 
>              ^
> 
>     Command was:

You didn't show us the command that was causing the error.  I am
thinking it might be a system view or function that references a renamed
system column.  I suggest dropping the view/function in the old cluster,
running pg_upgrade, then recreating the view with the new column name. 
Also, check the release notes for renamed columns.

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EnterpriseDB                             https://enterprisedb.com

  The usefulness of a cup is in its emptiness, Bruce Lee