On 2021-06-10 11:23, Andrew Dunstan wrote:
On 6/10/21 2:00 PM, Tom Lane wrote:
"Dean Gibson (DB Administrator)" <postgre...@mailpen.com> writes:
... Do I need quotes on the command line?
On 2021-06-10 09:54, Ranier Vilela wrote:
Your cmd lacks =
=>pg_dumpall -U Admin --exclude-database=MailPen >zzz.sql
I read [the manual] before posting, but missed that. Old command line patterns
die hard!
However, the result was the same: 3.5GB before running out of space.
[ experiments... ] Looks like you gotta do it like this:
pg_dumpall '--exclude-database="MailPen"' ...
This surprises me, as I thought it was project policy not to case-fold
command-line arguments (precisely because you end up needing weird quoting to
prevent that).
Ouch. That looks like a plain old bug. Let's fix it. IIRC I just used the same
logic that we use for pg_dump's --exclude-* options, so we need to check if
they have similar issues.
cheers, andrew
That works! I thought it was a quoting/case issue! I was next going to
try single quotes just outside double quotes, & that works as well (& is
a bit more natural):
pg_dumpall -U Admin --exclude-database='"MailPen"' >zzz.sql
Using mixed case has bitten me before, but I am not deterred! I run
phpBB 3.0.14 (very old version) because upgrades to more current
versions fail on the mixed case of the DB name, as well as the use of
SCHEMAs to isolate the message board from the rest of the data. Yes, I
reported it years ago.
I use lower-case for column, VIEW, & function names; mixed (camel) case
for table, schema, & database names; & upper-case for SQL keywords. It
helps readability (as does murdering a couple semicolons in the prior
sentence).
