Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id C41E66402B2 for ; Wed, 25 Mar 2009 16:53:49 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 65727-04-5 for ; Wed, 25 Mar 2009 16:53:38 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from yx-out-2324.google.com (yx-out-2324.google.com [74.125.44.30]) by mail.postgresql.org (Postfix) with ESMTP id 3D6B0640502 for ; Wed, 25 Mar 2009 16:20:53 -0300 (ADT) Received: by yx-out-2324.google.com with SMTP id 8so131550yxm.73 for ; Wed, 25 Mar 2009 12:20:51 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:sender:received:date :x-google-sender-auth:message-id:subject:from:to:content-type; bh=7yjYTuuv6LkdEZZf0UBC7nIbkZRIlOMGwdUPcIH2hiQ=; b=mFqU1M7zQMReNe6LGab3jz7cb7pnYQqVWB808TLC7QUwf+b688bILF1cpJelRiNHqG i5WFdP7GN3AVP6qgheiuY//XknAY1xeJ3/3cokSLItVUGwf0d/HnRsFLbHaZ2BoQIuw2 KRjBt0OXkOjC+eFv4nTK/cu2CNFFzxpvBSRY8= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:sender:date:x-google-sender-auth:message-id:subject :from:to:content-type; b=ous5joyeuT84PzW+gY4DXV9EouKZbnv9vEg6zd6Wl13pxEZctciWRMXeFIkiHWvSWL OR+N1v9X/teBqErkXNLPZTJOfWaVnatAKGUDf4VNGw8PYfTNvA2FVpIP4Jx/dugAlpT5 P1w/5No9m+HHaKyOpeHshJg5jn7vdL2+hiQxA= MIME-Version: 1.0 Received: by 10.100.189.10 with SMTP id m10mr1924395anf.153.1238008851380; Wed, 25 Mar 2009 12:20:51 -0700 (PDT) Date: Wed, 25 Mar 2009 14:20:51 -0500 X-Google-Sender-Auth: d55a3145686dc52f Message-ID: <7bbd319d0903251220n1c009a7i95b559387812bd85@mail.gmail.com> Subject: wal shipping/pg_standby docs patch From: Frank Wiles To: pgsql-docs@postgresql.org Content-Type: multipart/mixed; boundary=0016e64355e4d0bc6b0465f665fc X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200903/18 X-Sequence-Number: 5076 --0016e64355e4d0bc6b0465f665fc Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Hello, It has been awhile since I setup a warm standby server, so I dutifully followed the documentation. However, the documentation specifically suggests using 'cp -i' as the archive command. Granted, it does say that it is only a suggestion and not a recommendation, but does specifically mention it for Linux. Wasn't three days before I was bitten by transferring a WAL file before it was fully copied into the archive location. Attached is a patch that makes the suggestion be 'rsync -avr' in both backup.sgml and pg_standby.sgml. Thanks! -- Frank Wiles Revolution Systems | http://www.revsys.com/ frank@revsys.com | (800) 647-6298 --0016e64355e4d0bc6b0465f665fc Content-Type: text/x-diff; charset=US-ASCII; name="rsync-doc.patch" Content-Disposition: attachment; filename="rsync-doc.patch" Content-Transfer-Encoding: base64 X-Attachment-Id: f_fsqeetdq0 ZGlmZiAtdXIgcG9zdGdyZXNxbC1zbmFwc2hvdC9kb2Mvc3JjL3NnbWwvYmFja3VwLnNnbWwgbXkt cG9zdGdyZXNxbC9kb2Mvc3JjL3NnbWwvYmFja3VwLnNnbWwKLS0tIHBvc3RncmVzcWwtc25hcHNo b3QvZG9jL3NyYy9zZ21sL2JhY2t1cC5zZ21sCTIwMDktMDMtMDUgMTM6NTA6MDMuMDAwMDAwMDAw IC0wNjAwCisrKyBteS1wb3N0Z3Jlc3FsL2RvYy9zcmMvc2dtbC9iYWNrdXAuc2dtbAkyMDA5LTAz LTI1IDEzOjM1OjI0LjAwMDAwMDAwMCAtMDUwMApAQCAtNTY0LDcgKzU2NCw3IEBACiA8L3Byb2dy YW1saXN0aW5nPgogICAgIHdoaWNoIHdpbGwgY29weSBhcmNoaXZhYmxlIFdBTCBzZWdtZW50cyB0 byB0aGUgZGlyZWN0b3J5CiAgICAgPGZpbGVuYW1lPi9tbnQvc2VydmVyL2FyY2hpdmVkaXI8Lz4u ICAoVGhpcyBpcyBhbiBleGFtcGxlLCBub3QgYQotICAgIHJlY29tbWVuZGF0aW9uLCBhbmQgbWln aHQgbm90IHdvcmsgb24gYWxsIHBsYXRmb3Jtcy4pICBBZnRlciB0aGUKKyAgICByZWNvbW1lbmRh dGlvbiwgYW5kIG1pZ2h0IG5vdCB3b3JrIG9uIGFsbCBwbGF0Zm9ybXMuIEl0IGlzIGhpZ2hseSBy ZWNvbW1lbmQgeW91IHVzZSBhIHRvb2wgdGhhdCBkb2VzIGF0b21pYyBjb3BpZXMgc3VjaCBhcyA8 cHJvZ3JhbWxpc3Rpbmc+cnN5bmMgLWFydiAlcC4uLjwvcHJvZ3JhbWxpc3Rpbmc+KSAgQWZ0ZXIg dGhlCiAgICAgPGxpdGVyYWw+JXA8Lz4gYW5kIDxsaXRlcmFsPiVmPC8+IHBhcmFtZXRlcnMgaGF2 ZSBiZWVuIHJlcGxhY2VkLAogICAgIHRoZSBhY3R1YWwgY29tbWFuZCBleGVjdXRlZCBtaWdodCBs b29rIGxpa2UgdGhpczoKIDxwcm9ncmFtbGlzdGluZz4KZGlmZiAtdXIgcG9zdGdyZXNxbC1zbmFw c2hvdC9kb2Mvc3JjL3NnbWwvcGdzdGFuZGJ5LnNnbWwgbXktcG9zdGdyZXNxbC9kb2Mvc3JjL3Nn bWwvcGdzdGFuZGJ5LnNnbWwKLS0tIHBvc3RncmVzcWwtc25hcHNob3QvZG9jL3NyYy9zZ21sL3Bn c3RhbmRieS5zZ21sCTIwMDktMDItMjcgMDM6MzA6MjEuMDAwMDAwMDAwIC0wNjAwCisrKyBteS1w b3N0Z3Jlc3FsL2RvYy9zcmMvc2dtbC9wZ3N0YW5kYnkuc2dtbAkyMDA5LTAzLTI1IDEzOjI3OjQy LjAwMDAwMDAwMCAtMDUwMApAQCAtMjA3LDcgKzIwNyw3IEBACiAgIDxwYXJhPk9uIExpbnV4IG9y IFVuaXggc3lzdGVtcywgeW91IG1pZ2h0IHVzZTo8L3BhcmE+CiAKICAgPHByb2dyYW1saXN0aW5n PgotYXJjaGl2ZV9jb21tYW5kID0gJ2NwICVwIC4uLi9hcmNoaXZlLyVmJworYXJjaGl2ZV9jb21t YW5kID0gJ3JzeW5jIC1hcnogJXAgLi4uL2FyY2hpdmUvJWYnCiAKIHJlc3RvcmVfY29tbWFuZCA9 ICdwZ19zdGFuZGJ5IC1sIC1kIC1zIDIgLXQgL3RtcC9wZ3NxbC50cmlnZ2VyLjU0NDIgLi4uL2Fy Y2hpdmUgJWYgJXAgJXIgMj4+c3RhbmRieS5sb2cnCiAgIDwvcHJvZ3JhbWxpc3Rpbmc+Cg== --0016e64355e4d0bc6b0465f665fc--