Re: -f <output file> option for pg_dumpall

Andreas Pflug <pgadmin@pse-consulting.de>

From: Andreas Pflug <pgadmin@pse-consulting.de>
To: "Jim C. Nasby" <jim@nasby.net>
Cc: Dave Page <dpage@postgresql.org>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2007-01-08T23:09:27Z
Lists: pgsql-hackers
Jim C. Nasby wrote:
>
>
> It might make sense to provide a programmatic interface to pg_dump to
> provide tools like pgAdmin more flexibility. 
Are you talking about "pg_dump in a lib"? Certainly a good idea, because
it allows better integration (e.g. progress bar). 
> But it certainly doesn't make sense to re-create the dumping logic.
>
> In terms of integrating pg_dumpall and pg_dump; I don't really care if
> that happens, 
I can't make too much sense of integrating pg_dumpall anywhere. Dumping
a whole cluster is certainly much of a planned job, not an interactive
online one, because its output usually won't be usable except for
disaster recovery. Not much function to "re-create" here, single
exception is extracting cluster wide data, the -g option, that's why I
mentioned scripting. But apparently this didn't get into pgadmin svn any
more, so I need to retract this proposal.

Regards,
Andreas