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