Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 5C5A6B5DBDB for ; Tue, 9 Aug 2011 14:19:24 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 36751-08 for ; Tue, 9 Aug 2011 17:19:17 +0000 (UTC) X-Greylist: delayed 00:07:36.371212 by SQLgrey-1.7.6 Received: from forward17.mail.yandex.net (forward17.mail.yandex.net [95.108.253.142]) by mail.postgresql.org (Postfix) with ESMTP id A416FB5D8C5 for ; Tue, 9 Aug 2011 14:19:17 -0300 (ADT) Received: from web20.yandex.ru (web20.yandex.ru [95.108.253.229]) by forward17.mail.yandex.net (Yandex) with ESMTP id 827B810618A9; Tue, 9 Aug 2011 21:11:34 +0400 (MSD) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yandex.ru; s=mail; t=1312909894; bh=B7GfyKqYn5JCMNk5GgvgZmdZ4iYD/q95f7p+dIrZtUQ=; h=From:To:In-Reply-To:References:Subject:MIME-Version:Message-Id: Date:Content-Transfer-Encoding:Content-Type; b=Zsx+e6n8dJapQYk/bkBN9xAaSZPDq0N/H1DWJXtqlqp7/cuacGrJ3LIBTvUGH1GAj U8wQJ733qrakGiilX9g5b8fZ9MTlkpFP/GkXDbd7sZmi+I4urXX6mXhaDJ5AwFg+6x vGuFJTbwZH1ij0fNA/kDLE82yRH7ueEl6C313mpA= Received: from localhost (localhost.localdomain [127.0.0.1]) by web20.yandex.ru (Yandex) with ESMTP id 69BE86188302; Tue, 9 Aug 2011 21:11:34 +0400 (MSD) X-Yandex-Spam: 1 Received: from 87-253-24-83.pppoe.yaroslavl.ru (87-253-24-83.pppoe.yaroslavl.ru [87.253.24.83]) by web20.yandex.ru with HTTP; Tue, 09 Aug 2011 21:11:34 +0400 From: Vladimir Protasov Envelope-From: eoranged@yandex.ru To: pgsql-admin@postgresql.org,Kevin Grittner In-Reply-To: <4E411F60020000250003FCD3@gw.wicourts.gov> References: <725251312532201@web67.yandex.ru> <4E411F60020000250003FCD3@gw.wicourts.gov> Subject: Re: Read-only postgres instance MIME-Version: 1.0 Message-Id: <49881312909894@web20.yandex.ru> Date: Tue, 09 Aug 2011 21:11:34 +0400 X-Mailer: Yamail [ http://yandex.ru ] 5.0 Content-Transfer-Encoding: 8bit Content-Type: text/plain; charset=koi8-r X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=-10 required=5 tests=BAYES_20=-0.001, FREEMAIL_FROM=0.001 X-Spam-Level: X-Archive-Number: 201108/88 X-Sequence-Number: 38075 09.08.2011, 20:52, "Kevin Grittner" : > Vladimir Protasov wrote: > >> šI want to completely disallow postgres to write WAL and turn it to >> šread-only instance WAL-compatible with another instance. >> šIt is guarantied that there will be no write queries to the >> šserver, but I need to be sure about WAL. > > Have you considered setting it up as a hot standby, but then not > feeding it a WAL stream? Looks like what I've looked for. Thanks. > > -Kevin -- Best regards, Vladimir Protasov.