On Fri, Jan 16, 2009 at 9:18 PM, Leif Jensen <leif@xxxxxxxxxxx> 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." -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general