Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

Next:From: Tom LaneDate: 2009-08-11 16:33:20
Subject: Re: Moving filesystems
Previous:From: Peter JacksonDate: 2009-08-10 09:56:08
Subject: Help sub query

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group