It isn't guaranteed, but I think a clustered index on the attrs you want
the dump ordered by will give an ordered dump.
This may depend on your filesystem, and on what else your system
is doing at the time, as interupted disk reads may disrupt the sequence.
It has worked for me on Suse Linux wit
On Mon, 2008-11-10 at 17:05 -0800, Jeff Davis wrote:
> Is there any interest in an optional mode for pg_dump to order the
> output so that it's easier to use diff?
>
> I don't think it would make the output 100% deterministic, but it would
> make it easier to at least compare the data for small da
Jeff Davis wrote:
Is there any interest in an optional mode for pg_dump to order the
output so that it's easier to use diff?
I rsync my pg_dump output (-Fc -Z0), and I would appreciate an ordered
mode very much, along with anything else that makes the output as stable
as possible.
--
Kyle
Is there any interest in an optional mode for pg_dump to order the
output so that it's easier to use diff?
I don't think it would make the output 100% deterministic, but it would
make it easier to at least compare the data for small databases.
I think this has been brought up before, but I couldn
