Re: pg_restore woes..

Lamar Owen wrote:
> > Chris Bowlby wrote:
> > > Hi All,
> > >
> > > Ok, got one annoying issue with pg_restore, I'm trying to make use the
> > > re-order/remove option using a TOC listing. The catch is that no matter
> > > WHAT I do, it always imports the data for a particularily large table
> > > that I can get rid of or wait till the end of the import to have it
>
> On Thursday 02 January 2003 17:47, Bruce Momjian wrote:
> > Upgrade to 7.3. There were some bugs in the TOC handling in 7,2.X.
>
> I can't believe that's the best advice, given that the migration from 7.2 to
> 7.3 isn't the easiest one on the world. What happened to back porting some
> bugfixes to 7.2 from 7.3 because of that? Would this particular pg_restore
> fix be eligible for that treatment? If so, are there other fixes that might
> prompt a 7.2.4?

At the time I did the fix, I could have backpatched, but the number of
fixes was extensive. There were several places where the TOC tag didn't
match the object name, and once I was done it wasn't safe enough to
backpatch.

Also, most of the bugs were in the dump file, not the restore program,
so it would only have prevented problems if someone had used the newer
dump. I assume folks doing 7.2->7.3 mirgrations are not using TOC to
extract specific objects.

FYI, there is a fix for dumping DEFERRABLE/DEFERRED which will be
backpatched into 7.3.2 so folks upgrading to 7.4 will be OK. It is a
very small patch.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073