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
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? |