| From: | Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp> |
|---|---|
| To: | barry(at)e-rm(dot)co(dot)uk |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Replication |
| Date: | 2005-09-12 22:29:53 |
| Message-ID: | 20050913.072953.41630627.ishii@sraoss.co.jp |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> I currently have a postgresql 8 system which I want to replicate
> (ideally in realtime) with a spare host in order to introduce some
> redundancy - eg. if the master server dies then I've got a ready-to-go
> backup. Switchover does not have to be automated.
>
> I've looked into commandprompt.com's mammoth system, but it only
> supports up to 1000 tables (the documentation doesn't mention this!) -
> the database in question has more than 1000 tables, and adds new tables
> regularly. Slony-I and pgpool apparently don't support dynamic
> schemas, which I'd obviously need, so they're not quite up to the job
> either.
pgpool(without Slony-I) replicates schema changes. And PGCluter too.
--
SRA OSS, Inc. Japan
Tatsuo Ishii
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Simon Riggs | 2005-09-13 02:23:14 | Re: Replication |
| Previous Message | Brent Wood | 2005-09-12 21:54:18 | Re: SQL - planet redundant data |