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

Reply via email to