Re: Non-text mode for pg_dumpall
От | Nathan Bossart |
---|---|
Тема | Re: Non-text mode for pg_dumpall |
Дата | |
Msg-id | ZmcKMF61K4Ck51dK@nathan обсуждение исходный текст |
Ответ на | Non-text mode for pg_dumpall (Andrew Dunstan <andrew@dunslane.net>) |
Ответы |
Re: Non-text mode for pg_dumpall
Re: Non-text mode for pg_dumpall |
Список | pgsql-hackers |
On Mon, Jun 10, 2024 at 08:58:49AM -0400, Andrew Dunstan wrote: > Tom and Nathan opined recently that providing for non-text mode for > pg_dumpall would be a Good Thing (TM). Not having it has been a > long-standing complaint, so I've decided to give it a go. Thank you! > I think we would need to restrict it to directory mode, at least to begin > with. I would have a toc.dat with a different magic block (say "PGGLO" > instead of "PGDMP") containing the global entries (roles, tablespaces, > databases). Then for each database there would be a subdirectory (named for > its toc entry) with a standard directory mode dump for that database. These > could be generated in parallel (possibly by pg_dumpall calling pg_dump for > each database). pg_restore on detecting a global type toc.data would restore > the globals and then each of the databases (again possibly in parallel). I'm curious why we couldn't also support the "custom" format. > Following that I would turn my attention to using it in pg_upgrade. +1 -- nathan
В списке pgsql-hackers по дате отправления: