I used apt-get to install postgresql, running pg_config showing they are exactly the same... running on master: https://gist.github.com/1102148 running on slave: https://gist.github.com/1102151 On Sun, Jul 24, 2011 at 2:44 AM, Scott Marlowe <scott.marlowe@xxxxxxxxx> wrote: > On Sat, Jul 23, 2011 at 11:55 AM, Tomas Vondra <tv@xxxxxxxx> wrote: >> On 23 Červenec 2011, 18:14, Yan Chunlu wrote: >>> thanks for the help! >>> are there any other possible reasons? >>> >>> both system are using Debian amd64, as uname -a shows: >>> Linux washington 2.6.26-2-amd64 #1 SMP Tue Mar 9 22:29:32 UTC 2010 >>> x86_64 GNU/Linux >> >> It is not just about the architecture, it means the PostgreSQL was >> configured somehow differently during the build. E.g. a different block >> size or WAL block size would make such problems. >> >> Or maybe one of the buils might be 32-bit for some reason (you can run >> 32-bit system in a 64-bit environment). You can do this >> >> $ less postgres | grep Class >> >> to check this (ELF32 => 32bit, ELF64 => 64bit). >> >> Did you use the same binary packages or have you built the server yourself? > > Different date formats too. > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
