Re: [bug] Table not have typarray when created by single user mode

On 2020-Apr-14, wenjing wrote:

> However, if such a table exists, an error with pg_upgrade is further raised
> 
> ./initdb -k -D datanew
> ./pg_upgrade -d data -d datanew - b. -b.
> 
> Restoring database schemas in the new cluster
>   postgres                                                  
> *failure*
> 
> Consult the last few lines of "pg_upgrade_dump_13580.log" for
> the probable cause of the failure.
> Failure, exiting
> 
> pg_restore: from TOC entry 200; 1259 13581 TABLE t_create_by_standalone wenjing
> pg_restore: error: could not execute query: ERROR:  pg_type array OID value not set when in binary upgrade mode

Maybe the solution is to drop the table before pg_upgrade.

(Perhaps in --check mode pg_upgrade could warn you about such
situations.  But then, should it warn you specifically about random
other instances of catalog corruption?)

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services