Replication and PITR

From: Bo Lorentsen <bl(at)netgroup(dot)dk>
To: pgsql-general(at)postgresql(dot)org
Subject: Replication and PITR
Date: 2006-09-21 15:30:24
Message-ID: 4512B010.2050200@netgroup.dk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi ...

I have been trying to find a replication to a payment system at the
company I work, and Slony-I is of cause the first thing that game into
my attention. But when reading chapter 23.3 in the PG manual, there is
this comment of PITR used as a replication tool.

I also saw the "pgpitrha" project, and this sounds really nice too, but
is this a good way to go ? Will PITR be more replication friendly
in the future or even form the basis for a future buildin async
replication form ?

I may be naive, but to me it sound like we/I only need some kind of
protocol (or API in postgres) to move PITR data from one server to
another, and we could end up with a nice async replication system.

pros :
- DDL replications
- low overhead
- no trickers

Cons:
- binary alike master slave

Is this possible, or is it possible to write a module for PG that
provide this kind of transportation, or have I been spending too much
time together with MySQL :-)

Regards

/BL

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bill Moran 2006-09-21 15:39:06 Re: Replication and PITR
Previous Message gurkan 2006-09-21 15:13:57 Re: creating table while slony-I replication is running