7.4 - data recovery
От | Bartosz Belter |
---|---|
Тема | 7.4 - data recovery |
Дата | |
Msg-id | op.teub7fzetiul80@juniper.man.poznan.pl обсуждение исходный текст |
Список | 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
В списке pgsql-general по дате отправления: