Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 076802E325A for ; Wed, 23 Jan 2008 17:21:31 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 79033-02-3 for ; Wed, 23 Jan 2008 17:21:22 -0400 (AST) Received: from mail.ural.org (unknown [89.108.94.179]) by postgresql.org (Postfix) with ESMTP id 4A7122E3A3B for ; Wed, 23 Jan 2008 16:59:11 -0400 (AST) Received: from [85.115.165.254] by mail.ural.org with esmtpsa (TLSv1:AES256-SHA:256) (Exim 4.68) (envelope-from ) id 1JHpX8-0008DD-SB for pgsql-admin@postgresql.org; Thu, 24 Jan 2008 03:01:30 +0300 Date: Thu, 24 Jan 2008 01:59:02 +0500 From: Alexander Vysokovskih X-Mailer: The Bat! (v3.0) Professional Reply-To: Alexander Vysokovskih X-Priority: 3 (Normal) Message-ID: <1504012229.20080124015902@ural.org> To: pgsql-admin@postgresql.org Subject: lost /pg_xlog MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/231 X-Sequence-Number: 28005 Hi there, i have a situation on my sandbox: pg_xlog directory of cluster was gone at stopped postgres. it was on another disk which has broken. in this situation postgres falling to .core at startup with messages: --- LOG: could not open file "pg_xlog/000000030000000100000058" (log file 1, segment 88): No such file or directory LOG: invalid primary checkpoint record --- before that happened postgres was shutdown normally. i so understand that database is consistent, no? why we couldn't start? --- Alexander Vysokovskih