pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Bartosz Belter <bartosz.belter@man.poznan.pl>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: 7.4 - data recovery
Date: Fri, 25 Aug 2006 15:13:42 +0200
Message-ID: <op.teucc41jtiul80@juniper.man.poznan.pl> (raw)


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



view thread (3+ messages)  latest in thread

Message-ID: <op.teucc41jtiul80@juniper.man.poznan.pl>
Permalink:  ../op.teucc41jtiul80@juniper.man.poznan.pl/
Also on:    postgresql.org/message-id/op.teucc41jtiul80@juniper.man.poznan.pl

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: bartosz.belter@man.poznan.pl
  Subject: Re: 7.4 - data recovery
  In-Reply-To: <op.teucc41jtiul80@juniper.man.poznan.pl>
  References: <op.teucc41jtiul80@juniper.man.poznan.pl>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox