Re: Transferring databases to another Server - Mailing list pgsql-general

From Richard Huxton
Subject Re: Transferring databases to another Server
Date
Msg-id 441ABDEE.8090509@archonet.com
Whole thread Raw
In response to Transferring databases to another Server  (Harry Knitter <harry@knitter-edv-beratung.de>)
List pgsql-general
Harry Knitter wrote:
> Hello,
>
> after a crash of my 64-bit server I have set up a new server (32 bit).
> The harddsisk of the former server is now in my new server and I have access
> to the partion where the data were stored.
> I have tried the following:
> I copied the contents of /var/lib/pgsql from the old installation into the
> same directory of the new one.
> Restarting postgresql fails with the following entry in the log file:
>
> FATAL: wrong checksum in control file
>
> (the log entry I translated from German, so I don?t know if it is exact the
> same message having an English installation.)
>
> How can I fix this?

You can't just copy files between different platforms. You'll need to
use pg_restore to restore your last backup (or find another 64-bit
machine to run on).

--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: Sean Hamilton
Date:
Subject: Grant Priviliges on column
Next
From: Emi Lu
Date:
Subject: Re: About index for temporay table in a plpgsql function