From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Andrew Kohlsmith <akohlsmith(at)mixdown(dot)org> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: pg_dumpall forces plain text format |
Date: | 2002-07-13 00:57:57 |
Message-ID: | 200207130057.g6D0vv126023@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2002-07-13 19:27:27 | Re: It is a bug in pred_test()! (Was: [SQL] Please, HELP! Why is the query plan so wrong???) |
Previous Message | Niranjan Shivaratri | 2002-07-12 17:47:20 | Unable to install postgres on Mips platform. |