From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
---|---|
To: | Mike Howland <jkashoto(at)gmail(dot)com>, pgsql-novice(at)lists(dot)postgresql(dot)org |
Subject: | Re: Streaming replication |
Date: | 2017-12-04 07:16:02 |
Message-ID: | 1512371762.2462.10.camel@cybertec.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Mike Howland wrote:
> I have two machines where the secondary is configured as a backup of the primary machine.
> I used the instructions here: https://wiki.postgresql.org/wiki/Streaming_Replication
> to establish streaming replication...
> BTW, I'm using the 7.1 path (using backup/rsync/!backup) to prime the files on the secondary machine.
>
> Most of the time it comes up, connects and is quite happy.
> For my own sanity I have a bit of monitoring code that occasionally injects a change
> on the primary and watches for it to arrive on the secondary to ensure data is flowing.
> I also have some code that checks to see how close things are using pg_current_xlog_location()
> and pg_last_xlog_receive_location(). When things are working, these checks are always fine.
>
> Once in a while, this nonce value does not seem to be updated on the secondary server
> (although I can see it change on the primary).
> During this period of time, my watcher code also detects that pg_last_xlog_receive_location()
> is ahead of pg_current_xlog_location(). From what I can tell, the secondary has connected to the primary,
> it's just data does not seem to be flowing. I'll attach a bit of detal below.
The way you initialize the standby looks fine.
One explanation for the delay you observe would be if "max_standby_streaming_delay"
is set greater than zero and there are queries running on the standby that block
application of the changes streamed from the primary.
Yours,
Laurenz Albe
From | Date | Subject | |
---|---|---|---|
Next Message | Mike Howland | 2017-12-04 20:30:33 | Re: Streaming replication |
Previous Message | Mike Howland | 2017-12-03 02:29:50 | Streaming replication |