Thread: Dump/restore needed from 8.1b1 to 8.1.0?

I'm assuming no dump/restore cycle is needed for 8.1b1 to 8.1.0 upgrade?
Just wanted to be absolutely sure.

Thanks,
Sean

Sean Davis <sdavis2@mail.nih.gov> writes:
> I'm assuming no dump/restore cycle is needed for 8.1b1 to 8.1.0 upgrade?

I think you're wrong [ checks... ]  Yup, only b4 and up are initdb-
compatible with 8.1 final.

When in doubt, the authoritative story for this sort of thing may be
found here:
http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/catalog/catversion.h
CVS tags sharing the same catversion are initdb-compatible.

            regards, tom lane

On 11/9/05 11:37 AM, "Tom Lane" <tgl@sss.pgh.pa.us> wrote:

> Sean Davis <sdavis2@mail.nih.gov> writes:
>> I'm assuming no dump/restore cycle is needed for 8.1b1 to 8.1.0 upgrade?
>
> I think you're wrong [ checks... ]  Yup, only b4 and up are initdb-
> compatible with 8.1 final.
>
> When in doubt, the authoritative story for this sort of thing may be
> found here:
> http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/catalog/catversio
> n.h
> CVS tags sharing the same catversion are initdb-compatible.

For those like me who didn't check, postgresql gracefully halts on server
start with a complaint about catalog version mismatch, so the dump/restore
cycle is ongoing.

Thanks again, Tom.

Sean