Home > mailing lists

Re: Trouble with replication - Mailing list pgsql-general

From	Michael Paquier
Subject	Re: Trouble with replication
Date	June 6, 2013 04:42:41
Msg-id	CAB7nPqQuEKg_f8uiCbuqy+vVgGHmDsqLSFGybZhcUxRA8rbSZQ@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>) Re: Trouble with replication (David Greco <David_Greco@harte-hanks.com>)
List	pgsql-general

On Thu, Jun 6, 2013 at 7:23 AM, David Greco <David_Greco@harte-hanks.com> wrote:

On the master or on the slave, or on both? I thought shipping the archived WAL files from the master to the slave did this already?

In your case you need to transfer the WAL files using streaming replication, so you need to set wal_keep_segments to a value high enough on master such as the slave can can up. For reference:
http://www.postgresql.org/docs/9.2/static/runtime-config-replication.html

--
Michael

From: Adrian Klaver
Date: 06 June 2013, 03:30:59
Subject: Re: How to modify dump files created by pg_dump

From: Adrian Klaver
Date: 06 June 2013, 04:55:16
Subject: Re: How to modify dump files created by pg_dump