Slave server: FATAL: incorrect checksum in control file
Hi Guys,
I'm trying to set up a warm standby server, but have problems with running it on the backup. I feel that I have done like the documentation says:
The WAL is being copied to the slave using rsync.
Doing SELECT pg_start_backup(); (in psql)
Copying the data directory to the slave (using rsync)
Doing SELECT pg_stop_backup(); (in psql)
Making sure the slave is using it's own postgresql.conf and the recovery.conf is set with the pg_standby command.
.
So far I don't get any errors, but when I start postgres on the slave (I'm using pg_ctl), I get the error 'FATAL: incorrect checksum in control file'.
Both servers are running PostgreSQL-8.3.5, configured with exactly the same options (just prefix and ssl).
Any ideas ?
Greetings,
Leif
Import Notes
Reply to msg id not found: 24797815.1439221232058708169.JavaMail.root@quick
Leif Jensen <leif@crysberg.dk> writes:
So far I don't get any errors, but when I start postgres on the slave (I'm using pg_ctl), I get the error 'FATAL: incorrect checksum in control file'.
Both servers are running PostgreSQL-8.3.5, configured with exactly the same options (just prefix and ssl).
Maybe they aren't the same architecture? (32 vs 64 bit for instance)
regards, tom lane
You are perfectly right, master is 32bit and slave is 64bit. I didn't even consider that that would matter when "just" copying the data. First I was using different versions on the two boxes, but ended up installing 8.3.5 on both of them.
How do I install a 32bit PostgreSql on my 64bit (linux) box ?
Leif
----- "Tom Lane" <tgl@sss.pgh.pa.us> wrote:
Show quoted text
Leif Jensen <leif@crysberg.dk> writes:
So far I don't get any errors, but when I start postgres on the
slave (I'm using pg_ctl), I get the error 'FATAL: incorrect checksum
in control file'.Both servers are running PostgreSQL-8.3.5, configured with
exactly the same options (just prefix and ssl).
Maybe they aren't the same architecture? (32 vs 64 bit for instance)
regards, tom lane
Import Notes
Reply to msg id not found: 13127794.7351232158550277.JavaMail.root@quick | Resolved by subject fallback
On Fri, Jan 16, 2009 at 9:18 PM, Leif Jensen <leif@crysberg.dk> wrote:
You are perfectly right, master is 32bit and slave is 64bit. I didn't even consider that that would matter when "just" copying the data. First I was using different versions on the two boxes, but ended up installing 8.3.5 on both of them.
How do I install a 32bit PostgreSql on my 64bit (linux) box ?
Copy the 32 bit binaries from a 32 bit box. You'd be surprised how
well this works!
I once had the disconcerting realization that Someone Had Installed
Our RedHat IA-32 build on an AMD-64 (Opteron) system.
Nobody noticed until I was trying to add a C-based stored function,
and discovered, to my horror, that the binaries that had been running
fine (including Slony-I replication!) were for the wrong architecture
and a different flavour of Linux (compiled for Red Hat, running on
SuSE). I couldn't believe it had worked :-).
--
http://linuxfinances.info/info/linuxdistributions.html
Bob Hope - "I grew up with six brothers. That's how I learned to
dance - waiting for the bathroom."
That is almost too simple ;-)
Thanks for the suggestion,
Leif
----- "Christopher Browne" <cbbrowne@gmail.com> wrote:
Show quoted text
On Fri, Jan 16, 2009 at 9:18 PM, Leif Jensen <leif@crysberg.dk>
wrote:You are perfectly right, master is 32bit and slave is 64bit. I
didn't even consider that that would matter when "just" copying the
data. First I was using different versions on the two boxes, but ended
up installing 8.3.5 on both of them.How do I install a 32bit PostgreSql on my 64bit (linux) box ?
Copy the 32 bit binaries from a 32 bit box. You'd be surprised how
well this works!I once had the disconcerting realization that Someone Had Installed
Our RedHat IA-32 build on an AMD-64 (Opteron) system.Nobody noticed until I was trying to add a C-based stored function,
and discovered, to my horror, that the binaries that had been running
fine (including Slony-I replication!) were for the wrong architecture
and a different flavour of Linux (compiled for Red Hat, running on
SuSE). I couldn't believe it had worked :-).
--
http://linuxfinances.info/info/linuxdistributions.html
Bob Hope - "I grew up with six brothers. That's how I learned to
dance - waiting for the bathroom."