Re: Cannot pg_dump_all anymore...

E-BLOKOS <infos@xxxxxxxxxxxx> · Tue, 18 Mar 2025 19:16:23 -0700



    On 3/18/2025 5:49 AM, Greg Sabino
      Mullane wrote:

    
        First figure out which database is having that
          issue, by using pg_dump --schema-only on each database in
          turn. Then run this SQL on the database giving the error to
          see if the type exists, or what is nearby:
          

          select oid, typname, typtype, typnamespace::regnamespace
            from pg_type where oid <= 794978 order by 1 desc limit 3;
          

          Also let us know the version of pg_dump and the version
            of Postgres being dumped.
          

        Cheers,
        
          
            Greg
            

      select oid, typname, typtype, typnamespace::regnamespace from
      pg_type where oid <= 794978 order by 1 desc limit 3;
      

        oid   |  typname   | typtype | typnamespace
      

      --------+------------+---------+--------------
      

       794970 | log_17167  | c       | repack
      

       794969 | _log_17167 | b       | repack
      

       794966 | pk_17167   | c       | repack
      

      (3 rows)
      

      Arggh it's repack 🙁
      

      I have no clue how to repair repack....
    
    -- 
E-BLOKOS