Thread: Re: Slave server: FATAL: incorrect checksum in control file
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: > 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
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: > 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."