So I have a "data/base/myDB/" directory with a database that I need to
restore from Postgres 7.0.2 on a
Cobalt RaQ4 that went down. All I have is the
directory to work with, and I see these files that I need are in there. I opened
up one of the table files with a text editor and I could see all the data but
there was lots of garbled stuff around it. So, .... sigh of relief that the data
is in there .... but how can I get it out?
Having troubles restoring the data as I learn how
to do this. I copied this /myDB/ to my new /base/ directory and hoped it'd all
just work. Of course, when I try to connect to that database, it can't find the
database. So, I created a database with the same name as the one i need to
restore. Then, I copied the table files from the /base/ backup, hoping that the
tables would just show up with all my data. Nada. And I looked at the COPY
command and no luck. Can somebody help me?
Jeff Ward
