Re: pg_standby replication problem

On 06/09/2014 10:02 PM, Khangelani Gama wrote:
> -----Original Message-----
> From: Adrian Klaver [mailto:adrian(dot)klaver(at)aklaver(dot)com]
> Sent: Tuesday, June 10, 2014 1:42 AM
> To: Khangelani Gama; pgsql-general(at)postgresql(dot)org
> Subject: Re: [GENERAL] pg_standby replication problem
>
> On 06/09/2014 11:15 AM, Khangelani Gama wrote:
>> This is the standby replication setting with archive_command sending
>> the WALs from master to standby.
>>
>>
>
>
>
> Thanks for feedback from everyone, I will try and remove the correct old
> walfiles.
>
>
>
>
> What are the conf settings on the standby server?
>
>
>
> Standby server config settings are as follows:
>

My mistake, I should have been more specific.

What is in your recovery.conf file on the standby?

Is the standby something you really want to try to rescue at this point
or would it be feasible just to start over?

If you do decide to start over a little time spent on what you want to
happen would help out.

Options to look at:

1) Streaming replication. WAL files are streamed from master to standby.

2) Hot standby. The standby can process read only queries while in
standby mode.

3) Archiving. WAL files are archived in a location for possible use by
standby. Needs some mechanism to prune files or you could fill a disk again.

All 3 of the above can be combined if desired, which is where the
thinking time part comes in.

Places to start looking for information:

http://www.postgresql.org/docs/9.3/interactive/high-availability.html

https://wiki.postgresql.org/wiki/Binary_Replication_Tutorial

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com