Re: AWS forcing PG upgrade from v9.6 a disaster

"Dean Gibson (DB Administrator)" <postgresql@xxxxxxxxxxx> · Thu, 10 Jun 2021 10:43:13 -0700



    On 2021-06-10 09:54, Ranier Vilela
      wrote:

    
          Em qui., 10 de jun. de 2021
            às 13:08, Dean Gibson (DB Administrator) <postgresql@xxxxxxxxxxx>
            escreveu:

          
              I guess I don't understand what that option does:

              
              =>pg_dumpall -U Admin --exclude-database MailPen
              >zzz.sql

              pg_dump: error: could not write to output file: No space
              left on device

              pg_dumpall: error: pg_dump failed on database "MailPen",
              exiting

              
              I expected a tiny file, not 3.5GB.  "MailPen" is the only
              database (other than what's pre-installed).  Do I need
              quotes on the command line?

            
          See at:
          https://www.postgresql.org/docs/13/app-pg-dumpall.html
          

          Your cmd lacks =
          
            =>pg_dumpall -U Admin --exclude-database=MailPen
            >zzz.sql 

          
          regards, Ranier Vilela

          
    I read that before posting, but missed that.  Old command line
    patterns die hard!

    
    However, the result was the same:  3.5GB before running out of
    space.