| 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: | Whole Thread | Raw Message | 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
| 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 |