Bruce Momjian <[EMAIL PROTECTED]> writes: > Christopher Kings-Lynne wrote: >> Why is there no custom format dump option for pg_dumpall?
> I think it is because we have no mechanism to merge multiple custom > format files from different databases into a single file. Perhaps this > is a TODO. It would probably require changes in pg_dump to append custom-format output to an existing file, but offhand I see no fundamental obstacle now that pg_dumpall is a C program. (I think it would've been real painful to construct an archive from a shell script...) I'm envisioning some super-archive format in which there are individual entries containing the pg_dump output for each database, plus an entry for the "global" users-and-groups info. This does seem like a nice solution to the perennial problem of dumping blobs easily. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])