From: Simon Riggs <simon@2ndquadrant.com>
To: Tatsuo Ishii <t-ishii@sra.co.jp>
Cc: barry@e-rm.co.uk
Cc: pgsql-general@postgresql.org
Subject: Re: Replication
Date: Tue, 13 Sep 2005 16:21:04 -0700
Message-ID: <KGEFLMPJFBNNLNOOOPLGIEOPCIAA.simon@2ndquadrant.com> (raw)
In-Reply-To: <20050913.225402.39152157.ishii@sraoss.co.jp>
> From: Tatsuo Ishii [mailto:t-ishii@sra.co.jp]
> > 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?
Yes, currently log-file based replication is not recommended when the
transaction rate is either low or extremely variable.
I was regrettably unable to get a patch for that into 8.1
Best Regards, Simon Riggs
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-general@postgresql.org
Cc: simon@2ndquadrant.com, t-ishii@sra.co.jp, barry@e-rm.co.uk
Subject: Re: Replication
In-Reply-To: <KGEFLMPJFBNNLNOOOPLGIEOPCIAA.simon@2ndquadrant.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox