Re: Trouble with replication - Mailing list pgsql-general

From Michael Paquier
Subject Re: Trouble with replication
Date
Msg-id CAB7nPqR3dumm=+6pog7SZL90ux7yQ6L38Mg3K1W-Ej9-kRBQqw@mail.gmail.com
Whole thread Raw
In response to Re: Trouble with replication  (David Greco <David_Greco@harte-hanks.com>)
Responses Re: Trouble with replication  (David Greco <David_Greco@harte-hanks.com>)
List pgsql-general



On Thu, Jun 6, 2013 at 9:19 PM, David Greco <David_Greco@harte-hanks.com> wrote:
Then what is the purpose to shipping the archived WAL files to the slave? i.e. if wal_keep_segments has to be high enough to cover any replication lag anyways, then should I even bother shipping them over?
Oh. I just noticed that you set up restore_command on slave, so if streaming replication failed due to a WAL file already removed on master, slave process will try to fetch missing WAL files from the archive.
Could you provide more logs of slave? Are you sure that the missing WAL file was not fetched from the archive after failing to get it through streaming replication?
More details at paragraph "Standby Server Operation" here:
http://www.postgresql.org/docs/9.2/static/warm-standby.html
--
Michael

pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: PSA: If you are running Precise/12.04 upgrade your kernel.
Next
From: Toby Corkindale
Date:
Subject: Re: PSA: If you are running Precise/12.04 upgrade your kernel.