From martinbadie@yahoo.com Wed Oct  8 15:10:28 2008
Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 9D85437BCA1
	for <pgsql-admin-postgresql.org@postgresql.org>;
	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 <pgsql-admin-postgresql.org@postgresql.org>;
	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 <pgsql-admin@postgresql.org>; 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 <martinbadie@yahoo.com>
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

<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:times new roman,new york,times,serif;font-size:12pt"><div>Hi,<br><br>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.<br><br><br>Best Regards.<br></div></div><br>



      </body></html>
--0-1677372741-1223478611=:29150--




From cbbrowne@acm.org Wed Oct  8 17:07:53 2008
Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 816AC37C047
	for <pgsql-admin-postgresql.org@postgresql.org>;
	Wed,  8 Oct 2008 14:07:53 -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 86443-10 for <pgsql-admin-postgresql.org@postgresql.org>;
	Wed,  8 Oct 2008 14:07:49 -0300 (ADT)
Received: from news.hub.org (news.hub.org [200.46.204.72])
	by postgresql.org (Postfix) with ESMTP id C33C837BEF7
	for <pgsql-admin@postgresql.org>; Wed,  8 Oct 2008 14:07:49 -0300 (ADT)
Received: from news.hub.org (news.hub.org [200.46.204.72])
	by news.hub.org (8.14.1/8.14.1) with ESMTP id m98H7mQd042418
	for <pgsql-admin@postgresql.org>; Wed, 8 Oct 2008 14:07:48 -0300 (ADT)
	(envelope-from news@news.hub.org)
Received: (from news@localhost)
	by news.hub.org (8.14.1/8.14.1/Submit) id m98GnhYY018868
	for pgsql-admin@postgresql.org; Wed, 8 Oct 2008 13:49:43 -0300 (ADT)
	(envelope-from news)
From: Chris Browne <cbbrowne@acm.org>
X-Newsgroups: pgsql.admin
Subject: Re: replication with table add/removes..
Date: Wed, 08 Oct 2008 12:47:45 -0400
Organization: cbbrowne Computing Inc
Lines: 25
Message-ID: <87myhff2z2.fsf@dba2.int.libertyrms.com>
References: <103015.29150.qm@web59907.mail.ac4.yahoo.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
X-Complaints-To: usenet@news.hub.org
User-Agent: Gnus/5.110006 (No Gnus v0.6) XEmacs/21.4.21 (linux)
Cancel-Lock: sha1:rbdqpbHV+NGP3Df4orIJ5hJKJSc=
To: pgsql-admin@postgresql.org
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200810/57
X-Sequence-Number: 30513

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



From scott.marlowe@gmail.com Wed Oct  8 18:28:58 2008
Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 826A437B9D9
	for <pgsql-admin-postgresql.org@postgresql.org>;
	Wed,  8 Oct 2008 15:28:58 -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 04686-01 for <pgsql-admin-postgresql.org@postgresql.org>;
	Wed,  8 Oct 2008 15:28:55 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from rv-out-0506.google.com (rv-out-0506.google.com
 [209.85.198.232])
	by postgresql.org (Postfix) with ESMTP id 881B437B9AD
	for <pgsql-admin@postgresql.org>; Wed,  8 Oct 2008 15:28:55 -0300 (ADT)
Received: by rv-out-0506.google.com with SMTP id b25so4044468rvf.43
	for <pgsql-admin@postgresql.org>; Wed, 08 Oct 2008 11:28:54 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:received:received:message-id:date:from:to
	:subject:cc:in-reply-to:mime-version:content-type
	:content-transfer-encoding:content-disposition:references;
	bh=aeFe0bX8pC+ohB9zmJaBURqy/YieL3kZ5BuS/Ub1C00=;
	b=BpK3YXBHPQixs0va8i4BDKal7U34RBk0RL0o+Vv9zpAu8KngXovyQ8nH8K55Txqy6f
	8ruDSgIjX+fGpq570hVmrRv9BdmXSXfyeQfDuDnf6WBOeyFurvTWkPGwHyGl/bB7lf9l
	dYoixTZo7E+ls3dE7fc4/xUEO+3ohT1AqMZy4=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:to:subject:cc:in-reply-to:mime-version
	:content-type:content-transfer-encoding:content-disposition
	:references;
	b=YMxtwvTf5qaHT9Y8fExus6lb5dBawg8Rwcr9I3RVFCNJdSdJWQPoR2kJ1RR1qQcI/L
	gAGHXo2IKVu1sVuRNuO6q/+6v56W2fL9zc5lHnsZL25HHMJHIhCUEkEpABQUNnF7KoQ2
	Hz9J7LjHKfcAasbkvD/021n8XDEUypZWui1jQ=
Received: by 10.141.29.18 with SMTP id g18mr5299735rvj.162.1223490534374;
	Wed, 08 Oct 2008 11:28:54 -0700 (PDT)
Received: by 10.140.248.12 with HTTP; Wed, 8 Oct 2008 11:28:54 -0700 (PDT)
Message-ID: <dcc563d10810081128i25f9471cv81e8092d4094bd1b@mail.gmail.com>
Date: Wed, 8 Oct 2008 12:28:54 -0600
From: "Scott Marlowe" <scott.marlowe@gmail.com>
To: "Martin Badie" <martinbadie@yahoo.com>
Subject: Re: replication with table add/removes..
Cc: pgsql-admin@postgresql.org
In-Reply-To: <103015.29150.qm@web59907.mail.ac4.yahoo.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <103015.29150.qm@web59907.mail.ac4.yahoo.com>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=1.899 tagged_above=0 required=5
	tests=FS_REPLICA=1.179, SARE_SPEC_REPLICA=0.72
X-Spam-Level: *
X-Archive-Number: 200810/62
X-Sequence-Number: 30518

On Wed, Oct 8, 2008 at 9:10 AM, Martin Badie <martinbadie@yahoo.com> wrote:
> 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.

I think that pgpool might work for this.  There are probably some
other "front end" type replication systems that would work too.



From martinbadie@yahoo.com Thu Oct  16 08:10:32 2008
Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 0E038650074
	for <pgsql-admin-postgresql.org@postgresql.org>;
	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 <pgsql-admin-postgresql.org@postgresql.org>;
	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 <pgsql-admin@postgresql.org>; 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 <martinbadie@yahoo.com>
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 <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
Content-Type: text/html; charset=us-ascii

<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:times new roman,new york,times,serif;font-size:12pt"><div><br><br>How can I make them constantly create restore points? Once I create
recover.conf&nbsp; 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 &nbsp; <a rel="nofollow" target="_blank" href="http://www.postgresql.org/docs/8.3/interactive/continuous-archiving.html"><span class="yshortcuts" id="lw_1224144570_0">http://www.postgresql.org/docs/8.3/interactive/continuous-archiving.html</span></a><br><br></div><div style="font-family: times new roman,new york,times,serif; font-size: 12pt;"><br><div style="font-family: arial,helvetica,sans-serif; font-size: 13px;">----- Original Message ----<br>From: Chris Browne &lt;cbbrowne@acm.org&gt;<br>To: pgsql-admin@postgresql.org<br>Sent: Wednesday, October 8, 2008 7:47:45 PM<br>Subject: Re: [ADMIN] replication with table add/removes..<br><br>
<a ymailto="mailto:martinbadie@yahoo.com" href="mailto:martinbadie@yahoo.com">martinbadie@yahoo.com</a> (Martin Badie) writes:<br>&gt; Hi, I have a system that have constant table adds/removes are<br>&gt; present. I want to make a replication between master and slaves but<br>&gt; not sure which one is the best solution for that kind of a<br>&gt; situation. Since I am new to replication stuff on postgresql I am<br>&gt; truly lost but I know that Slony is not an answer for replications<br>&gt; where table add/remove are present.&nbsp; Best Regards.<br><br>The only way that is at all supportable right now in that regard is to use PITR:<br>&nbsp;  <a href="http://www.postgresql.org/docs/8.3/interactive/continuous-archiving.html" target="_blank">http://www.postgresql.org/docs/8.3/interactive/continuous-archiving.html</a><br><br>That does NOT allow you to query the backup nodes; in order to do so,<br>you must activate them, which amounts to failing over to the
 backup<br>node.<br><br>If your system doesn't have a stable schema, that seems like a<br>problem...<br>-- <br>select 'cbbrowne' || '@' || '<a target="_blank" href="http://linuxfinances.info">linuxfinances.info</a>';<br><a href="http://linuxdatabases.info/info/wp.html" target="_blank">http://linuxdatabases.info/info/wp.html</a><br>Objects &amp; Markets<br>"Object-oriented programming is about the modular separation of what<br>from how. Market-oriented, or agoric, programming additionally allows<br>the modular separation of why."<br>-- Mark Miller<br><br>-- <br>Sent via pgsql-admin mailing list (<a ymailto="mailto:pgsql-admin@postgresql.org" href="mailto:pgsql-admin@postgresql.org">pgsql-admin@postgresql.org</a>)<br>To make changes to your subscription:<br><a href="http://www.postgresql.org/mailpref/pgsql-admin" target="_blank">http://www.postgresql.org/mailpref/pgsql-admin</a><br></div></div></div><br>



      </body></html>
--0-123967506-1224144627=:25755--