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

From Magnus Hagander
Subject Re: Why warm-standby doesn't work using file-based log shipping method?
Date
Msg-id CABUevExd1CEp9ALHL0Zi8M1UTBfDoQUR7dC9a8Lu12aT+Y=v1A@mail.gmail.com
Whole thread Raw
In response to Re: Why warm-standby doesn't work using file-based log shipping method?  (Scott Mead <scottm@openscg.com>)
List pgsql-general
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/

pgsql-general by date:

Previous
From: Scott Mead
Date:
Subject: Re: Why warm-standby doesn't work using file-based log shipping method?
Next
From: "Albe Laurenz"
Date:
Subject: Re: ALTER DEFAULT PRIVILEGES target_role doesn't work with group roles