Re: [HACKERS] 7.0.2 -> 7.0.3 problem - anyone?

[ Charset ISO-8859-1 unsupported, converting... ]
> I think I might have explained this wrong..
>
> Ok, both databases had a BLCKSZ of 32k before the upgrade (in 7.0.2), one
> database that I upgraded first to 7.0.3 went flawlessly, it started, I can
> do every operation fine and it's BLCKSZ is 32k (so the BLCKSZ never changed
> between the installs, it is exactly as it was before).. I used the exact
> same procedure for my production database and it doesn't start..
>
> If I have to dump and reload in this situation, that's fine.. You absolutely
> know more than I do about PostgreSQL but I know what I did on the
> development machine and it didn't have these problems -- that's why I didn't
> think any dump and/or reload was needed...
>
> When I went back to 7.0.2, I shouldn't have had to dump and restore, should
> I? I never did an initdb on the 7.0.3 installation so the data (and
> virtually everything else as far as data is concerned was the same as when I
> was running 7.0.2
>
> Knowing all the above, do you still think a dump and reload was required? If
> so that's fine, I just need to know..

You are correct. It does not need a dump/restore.

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