On Tue, Feb 21, 2012 at 23:59, Scott Mead <scottm@xxxxxxxxxxx> wrote: > > On Tue, Feb 21, 2012 at 5:09 AM, sunpeng <bluevaley@xxxxxxxxx> 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/ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
