Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 135112E2D5E for ; Wed, 13 Feb 2008 01:36:35 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 02555-09 for ; Wed, 13 Feb 2008 01:36:32 -0400 (AST) Received: from mail1.yozons.com (mail1.yozons.com [63.251.168.100]) by postgresql.org (Postfix) with ESMTP id 8210D2E2D79 for ; Wed, 13 Feb 2008 01:36:32 -0400 (AST) Received: from [192.168.1.2] (pool-71-121-210-80.sttlwa.fios.verizon.net [71.121.210.80]) (authenticated bits=0) by mail1.yozons.com (8.12.10/8.12.10) with ESMTP id m1D5aUUF031628 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NOT) for ; Tue, 12 Feb 2008 21:36:31 -0800 Message-ID: <47B281E4.1090600@yozons.com> Date: Tue, 12 Feb 2008 21:36:36 -0800 From: David Wall Organization: Yozons Inc. User-Agent: Thunderbird 2.0.0.9 (Windows/20071031) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Re: warm database. References: <84D57263D486374587DA0820E60A2CC601ACA239@srit_mail.renaissance-it.com> In-Reply-To: <84D57263D486374587DA0820E60A2CC601ACA239@srit_mail.renaissance-it.com> 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=0.001 tagged_above=0 required=5 tests=BAYES_50=0.001 X-Spam-Level: X-Archive-Number: 200802/151 X-Sequence-Number: 28225 Without worrying about debugging your script, have you considered using pg_standby that's in contrib? It works well and you don't have to fuss with scripts unless you're doing something special. David