Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 44C399FBC14 for ; Tue, 24 Apr 2007 06:33:14 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 00866-01-5 for ; Tue, 24 Apr 2007 06:33:06 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from py-out-1112.google.com (py-out-1112.google.com [64.233.166.182]) by postgresql.org (Postfix) with ESMTP id 7588F9FBBCF for ; Tue, 24 Apr 2007 06:33:06 -0300 (ADT) Received: by py-out-1112.google.com with SMTP id a73so1549084pye for ; Tue, 24 Apr 2007 02:33:05 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:sender:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references:x-google-sender-auth; b=Gn02MW3WCkyAYWadp6mIBMmj+io6NEzkbF35/4Rm0OC9YfSXhl9JB46x81iNymRM+f3OjJfLyL7ycMfopCRaaHtREclWp3XAusiPtK6XiUMR6zT4sgTJzkc56QHXpmWGJvrgVuV5dd1eMyIB4DXZsRYz8Gy9UYFg83Xeid4TR4I= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:sender:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references:x-google-sender-auth; b=m+8ShwHgjtiH43XuSdB7ALemobCVS65mwxNqu8fKhRPtl7OAqbytxXQf9+BhFV8FxuW2ugED4FGsPPMbFv73qZstYG5nT4PB6RonP9YbAHG0vqyvDtrHCUyPF6tz7LNgdjMiLMUjEmL0Zx/NGkyMCUeLqO5Ps5Eza+L7W6AViWc= Received: by 10.65.211.16 with SMTP id n16mr13949904qbq.1177407185327; Tue, 24 Apr 2007 02:33:05 -0700 (PDT) Received: by 10.65.177.7 with HTTP; Tue, 24 Apr 2007 02:33:05 -0700 (PDT) Message-ID: <88daf38c0704240233v766a9a25w9abb502ed585fa7a@mail.gmail.com> Date: Tue, 24 Apr 2007 11:33:05 +0200 From: "Alexander Staubo" To: "Nimesh Satam" Subject: Re: Warm - standby system. Cc: pgsql-performance@postgresql.org, "Nimesh Satam" In-Reply-To: <965aa3ed0704240011y9e43cbaj957005ed0ca0e8d6@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <965aa3ed0704240011y9e43cbaj957005ed0ca0e8d6@mail.gmail.com> X-Google-Sender-Auth: 56a1e426b659a9b0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200704/404 X-Sequence-Number: 24281 On 4/24/07, Nimesh Satam wrote: > Can anybody let me know the steps which are supposed to be followed to make > the standby machine for read access? and how it should be one. Not possible at the moment. The warm standby is not "hot" -- it cannot be used for queries while it's acting as a standby. Explained here: http://www.postgresql.org/docs/8.2/static/warm-standby.html Alexander.