X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id D30533A4900 for ; Fri, 21 Jan 2005 13:33:55 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 10156-03 for ; Fri, 21 Jan 2005 13:33:39 +0000 (GMT) Received: from mail.grafton.lv (hornet.grafton.lv [159.148.13.2]) by svr1.postgresql.org (Postfix) with SMTP id 510B93A4A69 for ; Fri, 21 Jan 2005 13:33:37 +0000 (GMT) Received: (qmail 6363 invoked from network); 21 Jan 2005 13:33:31 -0000 Received: from krisha.grafton.lv (HELO 159.148.13.13) (159.148.13.13) by hornet.grafton.lv with SMTP; 21 Jan 2005 13:33:31 -0000 Date: Fri, 21 Jan 2005 15:33:28 +0200 From: Kristaps Armanis X-Mailer: The Bat! (v1.62i) Reply-To: Kristaps Armanis Organization: Grafton Entertainment X-Priority: 3 (Normal) Message-ID: <10071638046.20050121153328@grafton.lv> To: pgsql-admin@postgresql.org Cc: pgsql-general@postgresql.org Subject: Restoring fscked up postgres 7.1 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.525 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO, RCVD_NUMERIC_HELO X-Spam-Level: X-Archive-Number: 200501/232 X-Sequence-Number: 16091 Greetings, Some really strange things happened here. We were using old 7.1 postgres on 2.4 linux and db files living on ext3 partition for some time, vacuuming regulary and not upgrading only because software didn't worked with 7.2+. (developers where in progress, but not yet). Last night no crash, not anything, just @ one moment all records for last year where gone, all ros created for last year & tables created while this time - and not in only one database, but all 6 DB's on this server. In all DB's there is data like 2005-01-20 19:26:05+02 2005-01-20 19:26:02+02 and then next lines are 2004-04-15 18:19:23+03 2004-04-15 17:41:15+03 Looks like after IT, there is no problemm inserting or anything, just those records or tables before IT till 2004-04-15 18:19:23 are invisible. Data files ar there. Database created 3 month ago is displayed, but with no tables in it. We movied data directory, created newone, and restored from last night's dumps. The pain is that murphys law aplied in this case, and one of db's backup dumps was bad. I was ok some time ago, but it was failing for some last weeks or so, dump files ar 0, and pg_dump didn't notified anyhow.. strange Anyw ideas? Maybe there is some way to dump something out of raw psql data files? -- KRISHA