Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 386D61337BA6 for ; Mon, 18 Oct 2010 14:49:19 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 05501-03 for ; Mon, 18 Oct 2010 17:49:11 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from nrccenhts1.nrc.ca (nrccenhts2.nrc.ca [132.246.15.89]) by mail.postgresql.org (Postfix) with ESMTP id 3D50C1337B9F for ; Mon, 18 Oct 2010 14:49:09 -0300 (ADT) Received: from NRCWSTHCM1.NRC.CA (132.246.216.66) by nrccenhts2.nrc.ca (132.246.15.89) with Microsoft SMTP Server (TLS) id 8.1.436.0; Mon, 18 Oct 2010 13:49:08 -0400 Received: from [132.246.194.17] (132.246.216.202) by WSTMAIL.NRC.CA (132.246.216.66) with Microsoft SMTP Server (TLS) id 8.1.436.0; Mon, 18 Oct 2010 10:49:07 -0700 Message-ID: <4CBC8886.9040608@nrc-cnrc.gc.ca> Date: Mon, 18 Oct 2010 10:48:54 -0700 From: Isabella Ghiurea Reply-To: isabella.ghiurea@nrc-cnrc.gc.ca Organization: CADC -NRC User-Agent: Thunderbird 2.0.0.19 (X11/20090105) MIME-Version: 1.0 To: "pgsql-admin@postgresql.org" Subject: WAL log shipping + Streaming replication PG 9.0 questions Content-Type: text/plain; charset="ISO-8859-1"; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=2.018 tagged_above=-10 required=5 tests=BAYES_20=-0.001, FS_REPLICA=3.599, RCVD_IN_DNSWL_MED=-2.3, SARE_SPEC_REPLICA=0.72 X-Spam-Level: ** X-Archive-Number: 201010/149 X-Sequence-Number: 35890 Hi All, I have some questions regarding hot standby + streaming replication (PG 9.0) : what is master/primary server behavior if archive_command fails due to archive directory off line/unavailable? How about standby server behavior if restore command fails due to archive_master directory not available? Thank you Isabella -- -----------------------------------------------------------