Re: Forgot to dump old data before re-installing machine - Mailing list pgsql-general

From Tom Lane
Subject Re: Forgot to dump old data before re-installing machine
Date
Msg-id 10156.1200676379@sss.pgh.pa.us
Whole thread Raw
In response to Re: Forgot to dump old data before re-installing machine  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-general
Peter Eisentraut <peter_e@gmx.net> writes:
> What might be better is if we had an explicit endianness mark in pg_control
> rather than relying on users discovering endianness problems by seemingly
> corrupted version numbers.

Chicken-and-egg problem there: you won't know if there's an endianness
flag to check without having tested pg_control_version.

What would work better is to add some code that checks whether
pg_control_version looks like the byte-swap of a small number,
and prints a suitably modified error message if so.

I would not previously have thought this was worth the trouble,
but given what we now know about Apple's migration process,
it might be worth another half dozen lines of code and a new
error message.

What was that about string freeze ;-) ?

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Forgot to dump old data before re-installing machine
Next
From: "Dave Page"
Date:
Subject: Re: Forgot to dump old data before re-installing machine