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.