X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 82FD89FBA5F for ; Fri, 25 Aug 2006 10:46:47 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 42749-06-2 for ; Fri, 25 Aug 2006 10:46:35 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id A435F9FBA66 for ; Fri, 25 Aug 2006 10:46:32 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from rose.man.poznan.pl (rose.man.poznan.pl [150.254.173.3]) by svr4.postgresql.org (Postfix) with ESMTP id CCF695AF038 for ; Fri, 25 Aug 2006 13:13:46 +0000 (GMT) Received: from juniper.man.poznan.pl (juniper.man.poznan.pl [150.254.160.180]) (authenticated bits=0) by rose.man.poznan.pl (8.13.7/8.13.7/auth/ldap/milter/tls) with ESMTP id k7PDDgqX021325 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NOT) for ; Fri, 25 Aug 2006 15:13:43 +0200 (CEST) Date: Fri, 25 Aug 2006 15:13:42 +0200 To: "pgsql-admin@postgresql.org" Subject: 7.4 - data recovery From: "Bartosz Belter" Organization: PSNC Content-Type: text/plain; format=flowed; delsp=yes; charset=iso-8859-2 MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Message-ID: User-Agent: Opera Mail/9.01 (Linux) X-Virus-Scanned: by PSNC antivirus scanner at man.poznan.pl X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.168 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200608/285 X-Sequence-Number: 22828 -- I'm re-sending this email to pgsql-admin mailing list -- to get more people involved (already sent to -- pgsql-general) -- Very sorry, if it's not well seen on this mailing list! Hi, I'm not postgresql experienced user, so please forgive me, if I missed something obvious! I have the following problem: 1. Partition with postgresql v.7.4 data has been damaged 2. No backups! 3. I've recovered some files and it looks to me they're from $PGDATA/base/data/xxx (it looks this is the complete folder) 4. No other files! (no pg_clog, pg_xlog etc) I've tried to deal with the issue in the following way: 1. I created new database (named test) on new 7.4 PG instance (it creates /var/lib/postgresql/data/base/121339 folder for data) 2. I stopped the postgresql 3. Then I replaced the data in /var/lib/postgresql/data/base/121339 with my just recovered files 4. Then I started DB When I connect to "test" database I see no tables in the schema. Something went wrong! ;-( I realise this is not a best way (correct one) to recover data from damaged partition, but I have no idea how to proceed. It was my desperate try to recover those data - does anyone can advice me how to proceed? Is it possible to recover it at all? To clarify the issue, this is what I've got now: (the result of ls -l command in recovered directory) -rwxr-xr-x 1 bart users 49152 2006-08-25 10:54 1247 -rwxr-xr-x 1 bart users 311296 2006-08-25 10:54 1249 -rwxr-xr-x 1 bart users 532480 2006-08-25 10:54 1255 -rwxr-xr-x 1 bart users 90112 2006-08-25 10:54 1259 -rwxr-xr-x 1 bart users 16384 2006-08-25 10:54 16384 -rwxr-xr-x 1 bart users 16384 2006-08-25 10:54 16386 -rwxr-xr-x 1 bart users 0 2006-08-25 10:54 16388 -rwxr-xr-x 1 bart users 32768 2006-08-25 10:54 16390 ... -rwxr-xr-x 1 bart users 16384 2006-08-25 10:54 46575 -rwxr-xr-x 1 bart users 69385 2006-08-25 10:54 pg_internal.init -rwxr-xr-x 1 bart users 4 2006-08-25 10:54 PG_VERSION Thanks in advice for any help! best regards, Bartek -- ______________________________________________________________________ Bartosz Belter Network Research and Development bart@man.poznan.pl Poznan Supercomputing and Networking Center +48 61 858 20 28 http://www.man.poznan.pl ______________________________________________________________________