Re: dump, restore, dump yields differences - Mailing list pgsql-hackers

From Tom Lane
Subject Re: dump, restore, dump yields differences
Date
Msg-id 26569.1363978155@sss.pgh.pa.us
Whole thread Raw
In response to dump, restore, dump yields differences  (Kevin Grittner <kgrittn@ymail.com>)
Responses Re: dump, restore, dump yields differences
List pgsql-hackers
Kevin Grittner <kgrittn@ymail.com> writes:
> As part of testing the matview issues around dumping, I ran `make
> installcheck-world`, ran pg_dump to dump the regression database,
> loaded it into a new database, dumped the newly restored database,
> and compared the output files from the two pg_dump runs.� There
> were a few somewhat surprising differences, attached.� Do we want
> to worry about these, or leave them alone?

Those are expected.  You can trace the ALTER TABLE history of those
tables if you want to see why they're so odd, but basically there
are inheritance situations where it's hard to avoid this.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Kevin Grittner
Date:
Subject: dump, restore, dump yields differences
Next
From: Merlin Moncure
Date:
Subject: Re: Page replacement algorithm in buffer cache