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