Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 5860AB5DC39 for ; Fri, 5 Aug 2011 05:26:18 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 99252-05 for ; Fri, 5 Aug 2011 08:26:12 +0000 (UTC) X-Greylist: delayed 00:09:27.642226 by SQLgrey-1.7.6 Received: from forward2.mail.yandex.net (forward2.mail.yandex.net [77.88.46.7]) by mail.postgresql.org (Postfix) with ESMTP id F3228B5DC3F for ; Fri, 5 Aug 2011 05:26:11 -0300 (ADT) Received: from web67.yandex.ru (web67.yandex.ru [77.88.47.168]) by forward2.mail.yandex.net (Yandex) with ESMTP id 602F112A3805 for ; Fri, 5 Aug 2011 12:16:42 +0400 (MSD) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yandex.ru; s=mail; t=1312532202; bh=46r8XAB5B1rgBNsh6ipZWzAsXn3HHPxQ+A0lxlLNCiI=; h=From:To:Subject:MIME-Version:Message-Id:Date: Content-Transfer-Encoding:Content-Type; b=Hx9C7hJ0a5vQobYgEAhkERdnWDVbh1DPmJGILHWo2pvYbAN4CB3iIsOgxF59PlP6l i75vFmL5t9TJwWcH9DPcW+eQhVTW2Aepl4GZrP4jaZZA/9OcQBE2LynAc9an2FmsD8 d8A6KvRxCsMeDlUPh1WyO5s7Xd6zYlvJx6IL8NwU= Received: from localhost (localhost.localdomain [127.0.0.1]) by web67.yandex.ru (Yandex) with ESMTP id 534836C803A for ; Fri, 5 Aug 2011 12:16:42 +0400 (MSD) X-Yandex-Spam: 1 Received: from gw1.tensor.ru (gw1.tensor.ru [91.213.144.3]) by web67.yandex.ru with HTTP; Fri, 05 Aug 2011 12:16:41 +0400 From: Vladimir Protasov Envelope-From: eoranged@yandex.ru To: pgsql-admin@postgresql.org Subject: Read-only postgres instance MIME-Version: 1.0 Message-Id: <725251312532201@web67.yandex.ru> Date: Fri, 05 Aug 2011 12:16:41 +0400 X-Mailer: Yamail [ http://yandex.ru ] 5.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.811 tagged_above=-10 required=5 tests=BAYES_50=0.8, FREEMAIL_FROM=0.001, RCVD_IN_DNSWL_NONE=-0.0001, T_TO_NO_BRKTS_FREEMAIL=0.01 X-Spam-Level: X-Archive-Number: 201108/47 X-Sequence-Number: 38034 Hi, guys! 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. Is it possible? -- Best regards, Vladimir Protasov.