On Tue, Feb 21, 2012 at 23:59, Scott Mead <scottm@openscg.com> wrote:
>
> On Tue, Feb 21, 2012 at 5:09 AM, sunpeng <bluevaley@gmail.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/