Re: Forgot to dump old data before re-installing machine

From: Stefan Schwarzer <stefan(dot)schwarzer(at)grid(dot)unep(dot)ch>
To: Thomas Pundt <thomas(dot)pundt(at)rp-online(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Forgot to dump old data before re-installing machine
Date: 2008-01-16 14:02:52
Message-ID: A3B8F081-C7CF-4861-A045-CADEABAC6482@grid.unep.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-patches

> | 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Josh Harrison 2008-01-16 14:56:08 Re: Online Oracle to Postgresql data migration
Previous Message Martijn van Oosterhout 2008-01-16 13:48:13 Re: libpq updateable resultset?

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2008-01-16 15:25:56 Re: Forgot to dump old data before re-installing machine
Previous Message Gokulakannan Somasundaram 2008-01-16 13:55:13 Re: [HACKERS] Including Snapshot Info with Indexes