pg_dumpall doesn't support -s anymore?

Started by Martijn van Oosterhoutover 22 years ago2 messagesgeneral
Jump to latest
#1Martijn van Oosterhout
kleptog@svana.org

Hi,

Our backup scheme involves dumping the schema with pg_dumpall (including
users, groups, etc) using the -s option. Then the databases are dumped
individually with pg_dump -a. This works in 7.0.

In 7.3.3 this no longer works (the -a option is gone too).

Is there any particular reason for this?

Thanks in advance,
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/

Show quoted text

"All that is needed for the forces of evil to triumph is for enough good
men to do nothing." - Edmond Burke
"The penalty good people pay for not being interested in politics is to be
governed by people worse than themselves." - Plato

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Martijn van Oosterhout (#1)
Re: pg_dumpall doesn't support -s anymore?

Martijn van Oosterhout <kleptog@svana.org> writes:

In 7.3.3 this no longer works (the -a option is gone too).

If you're feeling desperate you could probably backpatch this 7.4 fix:

2003-05-30 19:55 tgl

* doc/src/sgml/ref/pg_dumpall.sgml, src/bin/pg_dump/pg_dumpall.c:
Cause pg_dumpall to support the -a, -s, -x options of pg_dump.

Is there any particular reason for this?

Oversight, I'd imagine.

regards, tom lane