Received: from localhost (uranus.hub.org [200.46.204.60]) by postgresql.org (Postfix) with ESMTP id 4A79A9FA1DB for ; Mon, 6 Nov 2006 16:29:41 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.60]) (amavisd-new, port 10024) with ESMTP id 43135-03 for ; Mon, 6 Nov 2006 16:29:37 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from web31804.mail.mud.yahoo.com (web31804.mail.mud.yahoo.com [68.142.207.67]) by postgresql.org (Postfix) with SMTP id 52CD89FB1F5 for ; Mon, 6 Nov 2006 16:29:37 -0400 (AST) Received: (qmail 46113 invoked by uid 60001); 6 Nov 2006 20:29:36 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=AgYlqG9yl36io/40v7UpA+N4w/vixHCcmV3Yl819N05rSgOBcSiRmEp1tJGyfPZlGYs5WHZKrw+qBEIikWY8rw7QCcS4sOIrAZN+rSkRrrAHrGirxPCZSvNeb/nylkcp7RLYPjUu4p4kfdBQV2I4ntF2Eka2rsfEOOEiO5h4vmw= ; X-YMail-OSG: Qm3cdxYVM1l.28EWliO_BoHZR8cLyN3fsAH0yQ9iG8grs4Ajk.zZovcf1ujxteY71O6O1dKSnKwGbH7S9PK06qk4LPQZpRU1sulmvYVU27V7bBqvw9YwGqjd7bFfMSBysvUmrzHIF40C_ggHG2MVjxGH.DG2pkwO5LfYlHzl96j5GLoFCKETLnrT3vFy Received: from [12.177.97.50] by web31804.mail.mud.yahoo.com via HTTP; Mon, 06 Nov 2006 12:29:35 PST Date: Mon, 6 Nov 2006 12:29:35 -0800 (PST) From: Richard Broersma Jr Subject: Re: About Distributed Database Systems To: Diego Souza , pgsql-admin@postgresql.org In-Reply-To: <44cc4d0b0611030450m5496db5cv71c084b23c18aac9@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Message-ID: <829799.45122.qm@web31804.mail.mud.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.929 tagged_above=0 required=5 tests=AWL, BAYES_00, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, DNS_FROM_RFC_WHOIS, INFO_TLD X-Spam-Level: X-Archive-Number: 200611/28 X-Sequence-Number: 23555 > My name is Diego, I am a Brazilian student, and I would know if there > is some version of PostgreSQL with features to work with distributed > database management. > Where I may to find some document about this functions? > > Thanks for attention I do not believe that the standard package of PostgreSQL support anything that allows you to distribute your database across various servers. However there are some contrib package that do this in various ways, depending upon what you want. If you want create a schema that is distributed across various databases you have the following choices: dblink, for postgres to postgres connection dbi-link, for postgres to anything else. http://pgfoundry.org/ For replication: you have slony, etc. al. http://slony.info/ Regards, Richard Broersma Jr.