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

From: Thomas Pundt <mlists(at)rp-online(dot)de>
To: pgsql-general(at)postgresql(dot)org, Stefan Schwarzer <stefan(dot)schwarzer(at)grid(dot)unep(dot)ch>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: Forgot to dump old data before re-installing machine
Date: 2008-01-16 13:02:14
Message-ID: 200801161402.14761.mlists@rp-online.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-patches

On Mittwoch, 16. Januar 2008, Stefan Schwarzer wrote:
| 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?

Ciao,
Thomas

--
Thomas Pundt <thomas(dot)pundt(at)rp-online(dot)de> ---- http://rp-online.de/ ----

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Russ Brown 2008-01-16 13:19:01 Sun acquires MySQL
Previous Message Teodor Sigaev 2008-01-16 13:01:54 Re: Segmentation fault with 8.3 FTS ISpell

Browse pgsql-patches by date

  From Date Subject
Next Message Gokulakannan Somasundaram 2008-01-16 13:55:13 Re: [HACKERS] Including Snapshot Info with Indexes
Previous Message Stefan Schwarzer 2008-01-16 11:26:00 Re: Forgot to dump old data before re-installing machine