X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 8A5A9D7F34 for ; Tue, 13 Sep 2005 16:00:37 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 42908-10 for ; Tue, 13 Sep 2005 19:00:32 +0000 (GMT) Received: from mail.gmx.net (pop.gmx.de [213.165.64.20]) by svr1.postgresql.org (Postfix) with SMTP id 2ABCED8D8E for ; Tue, 13 Sep 2005 16:00:30 -0300 (ADT) Received: (qmail invoked by alias); 13 Sep 2005 19:00:30 -0000 Received: from dsl-082-083-225-182.arcor-ip.net (EHLO colt.pezone.net) [82.83.225.182] by mail.gmx.net (mp017) with SMTP; 13 Sep 2005 21:00:30 +0200 X-Authenticated: #495269 From: Peter Eisentraut To: Russ Brown Subject: Re: Replication Date: Tue, 13 Sep 2005 21:00:29 +0200 User-Agent: KMail/1.8.1 Cc: pgsql-general@postgresql.org References: <4326F406.7010402@gmail.com> In-Reply-To: <4326F406.7010402@gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200509132100.29894.peter_e@gmx.net> X-Y-GMX-Trusted: 0 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.042 required=5 tests=[AWL=-0.008, FORGED_RCVD_HELO=0.05] X-Spam-Level: X-Archive-Number: 200509/511 X-Sequence-Number: 83527 Russ Brown wrote: > Apologies for going slighly off topic, but isn't this basically how > MySQL does replication? The PostgreSQL WAL log stores information on the level of "write these bytes to disk", the MySQL replication log stores information on the level of "user called this statement". So in MySQL, inserting the value of now() into a table might give different results if a slave runs in a different time zone. So it's sort of the same from the outside, but the internals are different and yield different possibilities and restrictions. -- Peter Eisentraut http://developer.postgresql.org/~petere/