Re: Problem reloading regression database

pgman wrote:
> I am testing pg_upgrade. I successfully did a pg_upgrade of a 7.2
> regression database into a fresh 7.2 install. I compared the output of
> pg_dump from both copies and found that c_star dump caused a crash. I
> then started doing more testing of the regression database and found
> that the regression database does not load in cleanly. These failures
> cause pg_upgrade files not to match the loaded schema.
>
> Looks like there is a problem with inheritance, patch attached listing
> the pg_dump load failures. I also see what looks like a crash in the
> server logs:
>
> DEBUG: pq_flush: send() failed: Broken pipe
> FATAL 1: Socket command type 1 unknown
>
> Looks like it should be fixed before final.

I should have been clearer how to reproduce this:

1) run regression tests
2) pg_dump regression > /tmp/dump
3) dropdb regression
4) createdb regression
5) psql regression < /tmp/dump > out 2> err

Look at the err file.

--
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