Re: [PATCHES] [GENERAL] Forgot to dump old data before re-installing machine

2008-01-18 Thread Tom Lane
"Dave Page" <[EMAIL PROTECTED]> writes: > On 18/01/2008, Peter Eisentraut <[EMAIL PROTECTED]> wrote: >> I didn't follow how the user got into this mess, so I don't know whether the >> suggestion "you need to initdb" is appropriate. > I would think not, as you almost certainly must be doing a file

Re: [PATCHES] [GENERAL] Forgot to dump old data before re-installing machine

2008-01-18 Thread Tom Lane
Peter Eisentraut <[EMAIL PROTECTED]> writes: > Here is a possible patch. Example output: > $ pg-install/bin/postgres -D pg-install/var/data > FATAL: database files are incompatible with server > DETAIL: The database cluster was initialized with PG_CONTROL_VERSION > 1090715648 (0x4103), but

Re: [PATCHES] [GENERAL] Forgot to dump old data before re-installing machine

2008-01-18 Thread Dave Page
On 18/01/2008, Peter Eisentraut <[EMAIL PROTECTED]> wrote: > Tom Lane wrote: > > 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. > > Here is a possible patch. E

Re: [PATCHES] [GENERAL] Forgot to dump old data before re-installing machine

2008-01-18 Thread Peter Eisentraut
Tom Lane wrote: > 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. Here is a possible patch. Example output: $ pg-install/bin/postgres -D pg-install/var/data FATAL