Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id B48B69FB9F1; Tue, 13 Mar 2007 13:29:51 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 42605-08; Tue, 13 Mar 2007 13:29:40 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from mail.metronet.co.uk (mail.metronet.co.uk [213.162.97.75]) by postgresql.org (Postfix) with ESMTP id 9A97D9FB9C0; Tue, 13 Mar 2007 13:29:39 -0300 (ADT) Received: from server3.office.archonet.com (84-51-143-99.archon037.adsl.metronet.co.uk [84.51.143.99]) by smtp.metronet.co.uk (MetroNet Mail) with ESMTP id 8B32A73ADA; Tue, 13 Mar 2007 16:29:34 +0000 (GMT) Received: from [192.168.1.36] (dell36.office.archonet.com [192.168.1.36]) by server3.office.archonet.com (Postfix) with ESMTP id 5E078274093; Tue, 13 Mar 2007 16:29:34 +0000 (GMT) Message-ID: <45F6D16E.5060607@archonet.com> Date: Tue, 13 Mar 2007 16:29:34 +0000 From: Richard Huxton User-Agent: IceDove 1.5.0.9 (X11/20061220) MIME-Version: 1.0 To: Joost Kraaijeveld Cc: Magnus Hagander , Tom Lane , pgsql-general@postgresql.org, pgsql-admin@postgresql.org Subject: Re: [GENERAL] PostgreSQL crashes on Windows 2003 References: <20070312143757.GB9966@svr2.hagander.net> <1173712845.20587.47.camel@panoramix> <45F5BE38.6040701@hagander.net> <1173803060.5010.15.camel@panoramix> In-Reply-To: <1173803060.5010.15.camel@panoramix> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200703/73 X-Sequence-Number: 24897 Joost Kraaijeveld wrote: > Hi all, > > Thanks for looking into it. The problem is solved: on both machines > there appeared to be a hung-up backup process that locked PostgreSQL. If that's a file-level backup, you'll want to exclude the PG directories (or stop the database while the backup occurs). -- Richard Huxton Archonet Ltd