Re: Trouble with replication

On 6/5/2013 1:39 PM, David Greco wrote:
>
> I've setup two 9.2.4 servers to serve as master-slave in a streaming
> replication scenario. I started with a fresh database on the master,
> setup the replication, then imported using pg_restore about 30GB of
> data. The master and slave are geographically separated, so
> replication of this amount of data can/should take hours. I saw from
> pg_last_xlog_receive_location and pg_last_xlog_replay_location that
> the slave began to receive the replication information, it eventually
> quit with the following errors in the log:
>
> 2013-06-05 16:28:43.198 EDT,,,19978,,51af9f7a.4e0a,2,,2013-06-05
> 16:28:42 EDT,,0,FATAL,XX000,"could not receive data from WAL stream:
> FATAL: requested WAL segment 000000010000000000000022 has already
> been removed
>
> ",,,,,,,,,""
>

I suspect you'll need to set the parameter that controls how many WAL
log files are kept on the server high enough to cover this replication
catchup period.

geographically separated high latency connections are very problematic
for any sort of replication.

--
john r pierce 37N 122W
somewhere on the middle of the left coast