Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 5421F1336FA7 for ; Mon, 24 Jan 2011 05:51:45 -0400 (AST) 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 24422-01 for ; Mon, 24 Jan 2011 09:51:39 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail.techbaza.pl (techbaza-r.3s.pl [85.14.102.154]) by mail.postgresql.org (Postfix) with SMTP id 84D9713364DE for ; Mon, 24 Jan 2011 05:51:37 -0400 (AST) Received: from [192.168.1.101] ([192.168.1.101]) by mail.techbaza.pl ; Mon, 24 Jan 2011 10:51:29 +0100 Message-ID: <4D3D4BA0.2060505@techbaza.pl> Date: Mon, 24 Jan 2011 10:51:28 +0100 From: Piotr Czekalski Organization: TECHBAZA.PL User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.1; pl; rv:1.9.2.12) Gecko/20101027 Thunderbird/3.1.6 ThunderBrowse/3.3.2 MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Re: loosing data in postgres database References: In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-5 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201101/70 X-Sequence-Number: 35017 W dniu 2011-01-24 10:37, victor katemana pisze: > hi everyone, i have a problem of loosing data in my postgres database > whenever i restart my machine what could be the possible problem help > me out? A plenty of reasons is possible, starting from uncommited transactions on shutdown till invalid fsync method or hardware problem (i.e. failed accu on Adaptec HW raid cache). Some more information is required to study your case, at least OS / config / hardware info. Regards, P. P.S. It sounds more likely being a topic to the administrator's list than PL/PGSQL list. -- -------------------------------------------------------------- "TECHBAZA.PL" Sp. z o.o. Technologie WEB, eDB& eCommerce Oddział Gliwice ul. Chorzowska 50 44-100 Gliwice tel. (+4832) 7186081 fax. (+4832) 7003289