| From: | Michael Paquier <michael(dot)paquier(at)gmail(dot)com> |
|---|---|
| To: | David Greco <David_Greco(at)harte-hanks(dot)com> |
| Cc: | John R Pierce <pierce(at)hogranch(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Trouble with replication |
| Date: | 2013-06-06 23:00:37 |
| Message-ID: | CAB7nPqR3dumm=+6pog7SZL90ux7yQ6L38Mg3K1W-Ej9-kRBQqw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, Jun 6, 2013 at 9:19 PM, David Greco <David_Greco(at)harte-hanks(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Toby Corkindale | 2013-06-07 02:25:02 | Re: PSA: If you are running Precise/12.04 upgrade your kernel. |
| Previous Message | Joshua D. Drake | 2013-06-06 22:51:43 | Re: PSA: If you are running Precise/12.04 upgrade your kernel. |