| 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: | Whole Thread | Raw Message | 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? |