Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id C02B764FFF4 for ; Thu, 13 Nov 2008 17:26:52 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 23726-02 for ; Thu, 13 Nov 2008 17:26:43 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail.autorevenue.com (mail.autorevenue.com [208.178.167.106]) by mail.postgresql.org (Postfix) with ESMTP id 2E47664FE15 for ; Thu, 13 Nov 2008 17:26:42 -0400 (AST) Received: (qmail 11354 invoked from network); 13 Nov 2008 16:26:21 -0500 Received: from unknown (HELO dei26g028534) (msteben@10.10.6.168) by mail.autorevenue.com with SMTP; 13 Nov 2008 16:26:21 -0500 From: "Mark Steben" To: Subject: question on warm standby Date: Thu, 13 Nov 2008 16:26:23 -0500 Message-ID: <77785C387FC44102BF108D152DC501C2@dei26g028534> MIME-Version: 1.0 Content-Type: text/plain; charset="KOI8-R" Content-Transfer-Encoding: quoted-printable X-Mailer: Microsoft Office Outlook 11 Thread-Index: AclF1npVJzK9M90OR/iB2gClIoRqJQ== X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.4325 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: 200811/73 X-Sequence-Number: 30727 Hi, My problem probably is that I need to look at the forest but am hyper-focusing on a maple twig. I have been looking at this for 2 days = now And would appreciate some feedback... I am running postgres 8.3.4 on master(mymachine) and slave(hummer). I = am attempting to implement warm standby. 1. On mymachine I have the following archive_command: Scp %p postgres@hummer:/var/backups/archlog/%f (scp has been set up with ssh keys so that password Is not required for postgres user) This works fine. Copies wal logs to the /var/backups/archlog = directory. 2. Before I attempt pg_standby or some other wait script on hummer I = have Used a simple cp command in my recovery.conf file to manually = restore My first set of updates: restore_command =3D 'cp /var/backups/archlog/%f %p' =20 From the doc I am assuming that %f should be the file name(s) of = the Wal log in /var/backups/archlog/ to be copied into the =20 /*/*/*/*/pg_xlog directory referenced by %p But %f seems to be referencing current wal log names in=20 /*/*/*/*/pg_xlog. I am getting messages like: =20 cp: cannot stat `/var/backups/archlog/0000000600000003000000D2':=20 No such file or directory 0000000600000003000000D2 is an actual wal log in hummer's /*/*/*/*/pg_xlog directory. How do I get the %f macro to reference the file names in the=20 /var/backups/archlog directory? Once I get past this, then I can play around with pg_standby and get Real warm_standby started. Thanks for your help, Committed to Creating @utoEnthusiasts. Please provide us with your = feedback. ________________________________ Mark Steben=81Database Administrator=81 @utoRevenueT 95 Ashley Ave. West Springfield, MA., 01089=20 413-243-4800 x1512 (Phone) =81 413-732-1824 (Fax) A Division of Dominion Enterprises =20 =20 =20 =20 =20