Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

Re: draft RFC: concept for partial, wal-based replication


  • From: Itagaki Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
  • To: Boszormenyi Zoltan <zb(at)cybertec(dot)at>
  • Cc: pgsql-hackers(at)postgresql(dot)org, hs(at)cybertec(dot)at, Andres Freund <andres(at)anarazel(dot)de>
  • Subject: Re: draft RFC: concept for partial, wal-based replication
  • Date: Mon, 30 Nov 2009 11:57:11 +0900
  • Message-id: <20091130115711.49FB.52131E4D@oss.ntt.co.jp> <text/plain>

Boszormenyi Zoltan <zb(at)cybertec(dot)at> wrote:

> we tried to discuss on a lower level what should be needed
> for a partial replication based on streaming replication.

We need to discuss a "partial recovery" before the partial replication.

There are some related items in out ToDo list and previous discussions:

http://wiki.postgresql.org/wiki/Todo
    - Allow WAL logging to be turned off for a table,
      but the table might be dropped or truncated during crash recovery
    - Allow WAL logging to be turned off for a table,
      but the table would avoid being truncated/dropped

- rmgr_hook
    http://archives.postgresql.org/pgsql-hackers/2008-12/msg01361.php

Could you try them first as a preparation for the partial replication?

Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center





Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group