veejar wrote:
Unfortunately I don't have any other information: dumps, other folders
from pgsql root directory.
What tools?
Start here:
http://sources.redhat.com/rhdb/
And you'll want to read and understand the Internals/Physical Storage
chapters of the manuals.
From past experience recovering data in a variety of circumstances, I'd
recommend getting what you can easily then writing the rest off as lost.
Chances are you may never get everything in a consistent state,
particularly as you've had disk problems which caused this in the first
place.
PS - Don't forget to cc: the mailing list when you reply. There are
plenty of people who know more than me around.
PPS - Make sure you have a backup of all the remaining files before you
begin.
PPPS - Don't forget to put a proper backup strategy in place once you've
recovered what you can.
Good Luck!
--
Richard Huxton
Archonet Ltd
---------------------------(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
