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