7.4 - data recovery

From: "Bartosz Belter" <bartosz(dot)belter(at)man(dot)poznan(dot)pl>
To: pgsql-general(at)postgresql(dot)org
Subject: 7.4 - data recovery
Date: 2006-08-25 13:10:17
Message-ID: op.teub7fzetiul80@juniper.man.poznan.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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

Browse pgsql-general by date

  From Date Subject
Next Message Peter Eisentraut 2006-08-25 13:18:23 Re: Can I read data load files without loading in db?
Previous Message macgillivary 2006-08-25 12:55:26 Re: How do i store arbitrary questions and answers in SQL?