Re: Why warm-standby doesn't work using file-based log shipping method?

On Tue, Feb 21, 2012 at 23:59, Scott Mead <scottm(at)openscg(dot)com> wrote:
>
> On Tue, Feb 21, 2012 at 5:09 AM, sunpeng <bluevaley(at)gmail(dot)com> wrote:
>>
>> I try to setup warm-standby using file-based log shipping method:
>> Master: 5432 port
>> Standby:6432 port at same machine
>> Master's :
>>
>> wal_level = archive
>> archive_mode = on
>> archive_command = 'cp %p /home/postgres/archive/%f'
>>
>> Standby's restore_command = 'cp /home/postgres/archive/%f %p'
>
> The slave's restore_command needs to be pg_standby (or similar) instead of
> 'cp' , cp will just kick and error and stop restoring on the first file it
> doesn't find.

Not in 9.1 (and later). Regular restore_command and set
standby_mode=on in recovery.conf is the easier way there.

--
 Magnus Hagander
 Me: http://www.hagander.net/
 Work: http://www.redpill-linpro.com/