Moving filesystems

From: Michael Lush <mjlush(at)ebi(dot)ac(dot)uk>
To: postgresql novice <pgsql-novice(at)postgresql(dot)org>
Subject: Moving filesystems
Date: 2009-08-11 15:19:27
Message-ID: Pine.LNX.4.64.0908111559250.25724@pigeon.ebi.ac.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice


I'm trying to set up a warm backup via log shipping, however when I
transfer the database filesystem(1) to the backup machine and start
postgres on it I get FATAL: incorrect checksum in control file.

Both machines are running postgres 8.2.5

The production server is running CentOS 5 (kernel 2.6.18.el5)
on a 4 CPU system (Dual Core AMD Opteron(tm) Processor 885)

The would be backup server is running CentOS 5.2 (kernel 2.6.18-92.el5PAE)
on a 2 CPU system (Intel(R) Xeon(TM) CPU 2.80GHz)

Should I expect this to work? or am I doing something dumb shunting the
files over (I tar'ed them and had to chown'ed them as the backup machines
user and group ID differs)

(1) I have tried this the production and a minimal test database (one
schema one table)

--
Michael
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Michael John Lush PhD Tel:44-1223 492626
Bioinformatician
HUGO Gene Nomenclature Committee Email: hgnc(at)genenames(dot)org
European Bioinformatics Institute
Hinxton, Cambridge
URL: http://www.genenames.org
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2009-08-11 16:33:20 Re: Moving filesystems
Previous Message Peter Jackson 2009-08-10 09:56:08 Help sub query