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

On 2021-06-10 09:54, Ranier Vilela wrote:
> Em qui., 10 de jun. de 2021 às 13:08, Dean Gibson (DB Administrator)
> <postgresql(at)mailpen(dot)com <mailto:postgresql(at)mailpen(dot)com>> 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
> <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.