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

Re: WAL log shipping + Streaming replication PG 9.0 questions

From: Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
To: isabella(dot)ghiurea(at)nrc-cnrc(dot)gc(dot)ca
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: WAL log shipping + Streaming replication PG 9.0 questions
Date: 2010-10-20 02:40:34
Message-ID: AANLkTi=YWFMV4x4tpdehhzb6z6zozKTURhnwUZvuPLWg@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
On Tue, Oct 19, 2010 at 11:46 PM, Isabella Ghiurea
<isabella(dot)ghiurea(at)nrc-cnrc(dot)gc(dot)ca> wrote:
> For the last question I ' m still a bit confused: if master_archive off line
> ( no archived WAL's available) what will be state of  standby server ?
> Basically we are trying to design a solution where WAL archived directory is
> not a "single point of failure"   for whole system ( we are planing to have
> WAL archived master directory on a separate machine and both server primary
> and standby will have read/write here) if this servers fails , we  want  to
>  be able to continue normal user operation on master while standby server
>  will have some latency.

You have three machines, the first is the master, the second is the standby,
and the last is something like NAS which has the archive area shared by them.
Right?

Even if the archive is unavailable, we can continue normal user operation
like INSERT/UPDATE/DELETE on the master until its pg_xlog has run out of
disk space (As I said before, a failure of archive_command continues to
accumulate unarchived WAL files in pg_xlog). So, you would need to check
periodically whether the archive is available or not by using a monitoring
tool, in order to prevent pg_xlog from running out of disk space.

On the other hand, even if the archive is unavailable, if the replication
connection is alive, the standby can receive the WAL and catch up with the
master. But, if the replication connection is terminated and the standby
cannot connect to the master because of the network outage, the standby can
read no WAL from neither the master nor the archive. In this case, the
standby would fall behind the master.

To prevent only one network outage from terminating the connection between
the master and the standby, and the connection between the archive and the
standby at the same time, we might need to use different networks for each.

Regards,

-- 
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center

In response to

Responses

pgsql-admin by date

Next:From: Robert TreatDate: 2010-10-20 03:42:03
Subject: Re: WAL log shipping + Streaming replication PG 9.0 questions
Previous:From: Isabella GhiureaDate: 2010-10-19 14:46:48
Subject: Re: WAL log shipping + Streaming replication PG 9.0 questions

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group