X-Original-To: pgsql-www-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 91E565E46BF for ; Sun, 15 Aug 2004 07:23:53 -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 43788-08 for ; Sun, 15 Aug 2004 10:23:49 +0000 (GMT) Received: from mail.iinet.net.au (mail-13.iinet.net.au [203.59.3.45]) by svr1.postgresql.org (Postfix) with SMTP id 87F115E37D0 for ; Sun, 15 Aug 2004 07:23:46 -0300 (ADT) Received: (qmail 17560 invoked from network); 15 Aug 2004 10:23:48 -0000 Received: from unknown (HELO ?192.168.10.3?) (203.217.60.98) by mail.iinet.net.au with SMTP; 15 Aug 2004 10:23:47 -0000 Message-ID: <411F39B5.60103@postgresql.org> Date: Sun, 15 Aug 2004 20:23:49 +1000 From: Justin Clift User-Agent: Mozilla Thunderbird 0.7.3 (Windows/20040803) X-Accept-Language: en-us, en MIME-Version: 1.0 To: "Marc G. Fournier" Cc: pgsql-www@postgresql.org Subject: Re: Distributed Database Web Site References: <20040814174753.U24290@ganymede.hub.org> In-Reply-To: <20040814174753.U24290@ganymede.hub.org> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200408/142 X-Sequence-Number: 4917 Marc G. Fournier wrote: > > Just curious, how hard would it be to distinguish on the main web site > between read and write operations? > > For instance, if we had a read-only database on a mirror site, > replicated from the main database using something like Slony ... how > hard would it be t have 'write operations' sent to the main web site to > happen, with all read operations being local? Thinking about what it would take... We'd need the pg_hba.conf of the main database set to allow connections from the mirror website(s), so the write operations can occur. Or, perhaps as an alternative, we could look at making the pages that generate writes only be on the main PG website. So, the majority of content is mirrored except for a few pages which do stuff like (i.e.) submit new stories and stuff. I haven't really played with Slony in the scenario of multiple mirrors that may or may not all be available at any one time, but Jan should be able to give input here. > ie. posting news events would happen at http://www.postgresql.org, but > reading news events would be @ http://www.xx.postgresql.org, but both > could/would be dynamic? Yep, should be possible. We just have to think about the technology we'd like web mirrors to run, and then ensure it's acceptable and do-able. :) Regards and best wishes, Justin Clift > ---- > Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) > Email: scrappy@hub.org Yahoo!: yscrappy ICQ: 7615664 > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)