Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 9D85437BCA1 for ; Wed, 8 Oct 2008 12:10:28 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 57055-08 for ; Wed, 8 Oct 2008 12:10:19 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from n1a.bullet.mail.ac4.yahoo.com (n1a.bullet.mail.ac4.yahoo.com [76.13.13.64]) by postgresql.org (Postfix) with SMTP id B42CE37C047 for ; Wed, 8 Oct 2008 12:10:18 -0300 (ADT) Received: from [76.13.13.26] by n1.bullet.mail.ac4.yahoo.com with NNFMP; 08 Oct 2008 15:10:17 -0000 Received: from [76.13.10.178] by t3.bullet.mail.ac4.yahoo.com with NNFMP; 08 Oct 2008 15:10:17 -0000 Received: from [127.0.0.1] by omp119.mail.ac4.yahoo.com with NNFMP; 08 Oct 2008 15:10:17 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 300614.17227.bm@omp119.mail.ac4.yahoo.com Received: (qmail 33196 invoked by uid 60001); 8 Oct 2008 15:10:13 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type:Message-ID; b=h0933Eq6fIT9m5uDdfHix6nlfvaJb3fvjptpxtXci94YrlGU4y2XFezRCKNTG4lRmQ2bCfyBa+CkLkBQgIVVSjLvuUEg4C2mqft1UQlM8TWQbcG8YzCx73P0D2An2pKqS5Zdz0pMjJ7ZY9bdNVn8NTWCjiTbJ4uysKAJIGL8/wA=; Received: from [85.105.2.186] by web59907.mail.ac4.yahoo.com via HTTP; Wed, 08 Oct 2008 08:10:11 PDT X-Mailer: YahooMailRC/1096.40 YahooMailWebService/0.7.218.2 Date: Wed, 8 Oct 2008 08:10:11 -0700 (PDT) From: Martin Badie Subject: replication with table add/removes.. To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1677372741-1223478611=:29150" Message-ID: <103015.29150.qm@web59907.mail.ac4.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.9 tagged_above=0 required=5 tests=FS_REPLICA=1.179, HTML_MESSAGE=0.001, SARE_SPEC_REPLICA=0.72 X-Spam-Level: * X-Archive-Number: 200810/51 X-Sequence-Number: 30507 --0-1677372741-1223478611=:29150 Content-Type: text/plain; charset=us-ascii Hi, I have a system that have constant table adds/removes are present. I want to make a replication between master and slaves but not sure which one is the best solution for that kind of a situation. Since I am new to replication stuff on postgresql I am truly lost but I know that Slony is not an answer for replications where table add/remove are present. Best Regards. --0-1677372741-1223478611=:29150 Content-Type: text/html; charset=us-ascii
Hi,

I have a system that have constant table adds/removes are present. I want to make a replication between master and slaves but not sure which one is the best solution for that kind of a situation. Since I am new to replication stuff on postgresql I am truly lost but I know that Slony is not an answer for replications where table add/remove are present.


Best Regards.

--0-1677372741-1223478611=:29150--