Re: recover from base directory?

some update... but still not working. so to resume i have base / pg_xlog (2
files and archives dir.) / pg_clog - BUT no global. i reinstalled postgresql
8.0.4 (same version of my backup data/). initdb, createdb mydb1, mydb2 mydb3
and move pg_xlog and _clog over the data. rename my base to fit the oid.

starting postmaster is working fine, but i had to do a pg_resetxlog and now
it start like normal. but the problem is when i pgsql mydb1 \d no relations
founds...

what can i do?
pat




----- Original Message -----
From: "patrick" <patrick@11h11.com>
To: <pgsql-general@postgresql.org>
Sent: Tuesday, April 04, 2006 3:45 AM
Subject: [GENERAL] recover from base directory?


> hi all,
>
> 1) do backup always... on cd, tape, raid. my hd just burn.
>
> there is hope for me, in lost+found there is a directory called base with
> multiples sub-direcotry (403274 for example). is this my database, can i
> recover them with thoses directory?
>
> look in the archive for recover base... nothing really like that was
> explain... but sorry if it's somewhere!!!
>
> pat
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
>       choose an index scan if your joining column's datatypes do not
>       match
>