| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
| Cc: | pgsql-patches(at)postgresql(dot)org, "Dave Page" <dpage(at)postgresql(dot)org>, "Stefan Schwarzer" <stefan(dot)schwarzer(at)grid(dot)unep(dot)ch>, "Martijn van Oosterhout" <kleptog(at)svana(dot)org> |
| Subject: | Re: [GENERAL] Forgot to dump old data before re-installing machine |
| Date: | 2008-01-18 19:18:40 |
| Message-ID: | 11542.1200683920@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-patches |
Peter Eisentraut <peter_e(at)gmx(dot)net> 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 (0x41030000), but the server was compiled with PG_CONTROL_VERSION 833 (0x00000341).
> HINT: This could be a mismatched byte order. It looks like you need to initdb.
> 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 think it still is, at least as much as it is in other situations where
we say that. I didn't like the wording of the other part of the hint
though. Maybe "This could be a problem of mismatched byte ordering"?
Other than that quibble, +1.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joanne Salerno | 2008-01-18 19:20:10 | Default_with_oids |
| Previous Message | Dave Page | 2008-01-18 19:16:39 | Re: [GENERAL] Forgot to dump old data before re-installing machine |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Smith | 2008-01-18 19:48:11 | Re: Forgot to dump old data before re-installing machine |
| Previous Message | Dave Page | 2008-01-18 19:16:39 | Re: [GENERAL] Forgot to dump old data before re-installing machine |