Re: Cascade Standby Configuration in 9.2.4 - Mailing list pgsql-admin

From Scott Ribe
Subject Re: Cascade Standby Configuration in 9.2.4
Date
Msg-id 53779B8A-7926-4C62-BABE-A6811B6CBF6D@elevated-dev.com
Whole thread Raw
In response to Re: Cascade Standby Configuration in 9.2.4  (Murthy Nunna <mnunna@fnal.gov>)
List pgsql-admin
On Apr 1, 2014, at 5:20 PM, Murthy Nunna <mnunna@fnal.gov> wrote:

> Thanks for the clarification Scott... What is the restore_command in recovery.conf does in case of streaming
replicationif it doesn't need logs available locally on the slave machine. 

It copies the files. It has no way of knowing whether or not there's a WAL-shipping replica out there somewhere which
needsthem. 

> Do you think if the streaming falls behind, then slave will request master to ship logs??????

The slave does not request the master to ship logs. The slave, when started uses the WAL files it finds in its
locally-availableWAL archive, then starts streaming from the master, which requires that there not be a gap between its
localcopies and what's still available on the master. 

This is all covered in the documentation:

<http://www.postgresql.org/docs/9.2/static/high-availability.html>

--
Scott Ribe
scott_ribe@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice






pgsql-admin by date:

Previous
From: Murthy Nunna
Date:
Subject: Re: Cascade Standby Configuration in 9.2.4
Next
From: Murthy Nunna
Date:
Subject: Archive param questions?