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

From Stefan Schwarzer
Subject Re: Forgot to dump old data before re-installing machine
Date
Msg-id A3B8F081-C7CF-4861-A045-CADEABAC6482@grid.unep.ch
Whole thread Raw
In response to Re: Forgot to dump old data before re-installing machine  (Thomas Pundt <mlists@rp-online.de>)
Responses Re: Forgot to dump old data before re-installing machine  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
> | The logfile is telling me this when I try to start the server with
> my
> | "old" data folder:
> |
> | FATAL:  database files are incompatible with server
> | DETAIL:  The database cluster was initialized with
> PG_CONTROL_VERSION
> | 738394112, but the server was compiled with PG_CONTROL_VERSION 812.
> |
> | What does it mean? I have and had 8.1 installed...
>
> I didn't follow the thread, but look at the output of
>
>  $ printf "%x\n" 738394112
>  2c030000
>
> and
>
>  $ printf "%x\n" 812
>  32c
>
> This looks like an endianess mismatch; did you already mention on what
> architecture you are on?

MacPro, Leopard

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: libpq updateable resultset?
Next
From: "Josh Harrison"
Date:
Subject: Re: Online Oracle to Postgresql data migration