Postgres Pro
Downloads
Home   >   mailing lists

Re: AWS forcing PG upgrade from v9.6 a disaster - Mailing list pgsql-performance

From Dean Gibson (DB Administrator)
Subject Re: AWS forcing PG upgrade from v9.6 a disaster
Date
Msg-id 4abbbebd-1496-7376-136f-38eb91773cd2@mailpen.com
Whole thread Raw
In response to Re: AWS forcing PG upgrade from v9.6 a disaster  (Ranier Vilela <ranier.vf@gmail.com>)
Responses Re: AWS forcing PG upgrade from v9.6 a disaster  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: AWS forcing PG upgrade from v9.6 a disaster  ("Dean Gibson (DB Administrator)" <postgresql@mailpen.com>)
List pgsql-performance
Tree view
On 2021-06-10 09:54, Ranier Vilela wrote:
Em qui., 10 de jun. de 2021 às 13:08, Dean Gibson (DB Administrator) <postgresql@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:

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.

pgsql-performance by date:

Previous
From: Vijaykumar Jain
Date:
Subject: Re: waiting for client write
Next
From: Tom Lane
Date:
Subject: Re: AWS forcing PG upgrade from v9.6 a disaster