Andrew Kohlsmith wrote:
> > > Is there a particular reason why plain text is forced?
> > Because pg_dumpall is producing a script file.
> > This is obviously not optimal, but it's not very clear how to do better.
>
> Agreed. :-)
>
> I notice that pg_dumpall just uses a query to grab a list of databases and
> some information about them and then cycles through them and runs pg_dump for
> each one to dump it. I could easily do this myself but that would mean that
> both pg_dumpall and whatever method I come up with do not guarantee
> referential integrity across databases (I'm specifically thinking about
> foreign keys).
>
> Now IIRC, Postgres doesn't allow foreign keys across databases so this point
> is moot at this time. Is there a way to start a transaction at the start of
> the dump and hold it throughout successive connections, finally releasing it
> at the end? Or is that on the TODO for whenever foreign keys can be across
> databases?
That is far off our TODO radar, perhaps never. Sorry.
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026