[Pgpool-hackers] Partial replication

Tatsuo Ishii ishii at sraoss.co.jp
Mon Feb 21 23:33:52 UTC 2011


>> Year to store large configuration data, we could use PostgreSQL
>> itself. One thing I want to do is, getting ride of system DB. We could
>> use one of DB nodes for this purpose, no?
>> 
> 
> We need to have this on each node. It would be really sad if the only
> node with the information just crash.

Why don't we replicate the config tables to all DB nodes?

>> Another problem we have to resolve is, online recovery. Probably we
>> need to wait for the day when PostgreSQL can do the base backup
>> partialy.
> 
> Meaning we'll wait quite a long time. Partial replication is a long way
> to go.

Right. I hope we could find alternative way.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp


More information about the Pgpool-hackers mailing list