Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 0E038650074 for ; Thu, 16 Oct 2008 05:10:32 -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 71659-08 for ; Thu, 16 Oct 2008 05:10:29 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from n5.bullet.mail.ac4.yahoo.com (n5.bullet.mail.ac4.yahoo.com [76.13.13.27]) by postgresql.org (Postfix) with SMTP id 3579E64FC00 for ; Thu, 16 Oct 2008 05:10:29 -0300 (ADT) Received: from [76.13.13.26] by n5.bullet.mail.ac4.yahoo.com with NNFMP; 16 Oct 2008 08:10:27 -0000 Received: from [76.13.10.174] by t3.bullet.mail.ac4.yahoo.com with NNFMP; 16 Oct 2008 08:10:27 -0000 Received: from [127.0.0.1] by omp115.mail.ac4.yahoo.com with NNFMP; 16 Oct 2008 08:10:27 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 468827.87119.bm@omp115.mail.ac4.yahoo.com Received: (qmail 28056 invoked by uid 60001); 16 Oct 2008 08:10:27 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type:Message-ID; b=M87aaJJbYnkdZTzWWiLQJncX/jOySsF6yfiJlkvn9phz7cfIIdeYv2zIR2Kjeec1n9w6hJD5/MniGvnzYezOipDJMYg8vfxjM+eramZma8tzMfog9L/WbcFzgfsebpTG0eU0fCjFFByqYfQ7ggA4xLuWm4XNfA/5M+YJKQlAcgY=; X-YMail-OSG: BP0WCjMVM1luJF3bdZEW0BJVl2V_MlURnpp_2WKi6H.KLVCedQ2Ls52NLNDKq22iiAphkOy9m496UkmJr.pmZ318CLo6X4.ZKNy0qpnq1sPxtVDbUxuOod80BtjLxyZxZg.RukH_9ktrgGiOprYNgaZD7ks- Received: from [212.156.51.22] by web59902.mail.ac4.yahoo.com via HTTP; Thu, 16 Oct 2008 01:10:27 PDT X-Mailer: YahooMailRC/1096.40 YahooMailWebService/0.7.218.2 Date: Thu, 16 Oct 2008 01:10:27 -0700 (PDT) From: Martin Badie Subject: Re: replication with table add/removes.. To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-123967506-1224144627=:25755" Message-ID: <362245.25755.qm@web59902.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/116 X-Sequence-Number: 30572 --0-123967506-1224144627=:25755 Content-Type: text/plain; charset=us-ascii How can I make them constantly create restore points? Once I create recover.conf it creates recover.done but what about those new queries that comes after that? Do I have to re-create recover.conf? Or how do I achive constant logging to slaves? This issue is not clear in the documentation http://www.postgresql.org/docs/8.3/interactive/continuous-archiving.html ----- Original Message ---- From: Chris Browne To: pgsql-admin@postgresql.org Sent: Wednesday, October 8, 2008 7:47:45 PM Subject: Re: [ADMIN] replication with table add/removes.. martinbadie@yahoo.com (Martin Badie) writes: > 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. The only way that is at all supportable right now in that regard is to use PITR: http://www.postgresql.org/docs/8.3/interactive/continuous-archiving.html That does NOT allow you to query the backup nodes; in order to do so, you must activate them, which amounts to failing over to the backup node. If your system doesn't have a stable schema, that seems like a problem... -- select 'cbbrowne' || '@' || 'linuxfinances.info'; http://linuxdatabases.info/info/wp.html Objects & Markets "Object-oriented programming is about the modular separation of what from how. Market-oriented, or agoric, programming additionally allows the modular separation of why." -- Mark Miller -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin --0-123967506-1224144627=:25755 Content-Type: text/html; charset=us-ascii


How can I make them constantly create restore points? Once I create recover.conf  it creates recover.done but what about those new queries that comes after that? Do I have to re-create recover.conf? Or how do I achive constant logging to slaves? This issue is not clear in the documentation   http://www.postgresql.org/docs/8.3/interactive/continuous-archiving.html


----- Original Message ----
From: Chris Browne <cbbrowne@acm.org>
To: pgsql-admin@postgresql.org
Sent: Wednesday, October 8, 2008 7:47:45 PM
Subject: Re: [ADMIN] replication with table add/removes..

martinbadie@yahoo.com (Martin Badie) writes:
> 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.

The only way that is at all supportable right now in that regard is to use PITR:
  http://www.postgresql.org/docs/8.3/interactive/continuous-archiving.html

That does NOT allow you to query the backup nodes; in order to do so,
you must activate them, which amounts to failing over to the backup
node.

If your system doesn't have a stable schema, that seems like a
problem...
--
select 'cbbrowne' || '@' || 'linuxfinances.info';
http://linuxdatabases.info/info/wp.html
Objects & Markets
"Object-oriented programming is about the modular separation of what
from how. Market-oriented, or agoric, programming additionally allows
the modular separation of why."
-- Mark Miller

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

--0-123967506-1224144627=:25755--