| From: | Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp> |
|---|---|
| To: | simon(at)2ndquadrant(dot)com |
| Cc: | barry(at)e-rm(dot)co(dot)uk, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Replication |
| Date: | 2005-09-13 13:54:02 |
| Message-ID: | 20050913.225402.39152157.ishii@sraoss.co.jp |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> You can use PITR to archive transaction logs to a second server that is
> kept in standby mode.
>
> This will cope with any number of tables and cope with dynamic changes
> to tables.
>
> This is fairly straightforward and very low overhead.
> Set archive_command to a program that transfers xlog files to second
> server.
> Then set restore_command on the second server to a program that loops
> until the next file is available.
> Switchover time is low.
I thought there are some issues of log based replication (I don't
remeber details though). Have they been resolved recently?
--
SRA OSS, Inc. Japan
Tatsuo Ishii
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrey Fomichev | 2005-09-13 14:48:57 | Re: PostgreSQL and XML support |
| Previous Message | Reid Thompson | 2005-09-13 13:12:17 | Re: Utility that creates table schema from csv data? |