>Sorry for my stupid question, but what are you tell is that I can not get back my data if I just make a copy?. I mean, only using the pg_dump function is the way that I can get back my tables again?
>
>Or can I run that process in the simple copy of my data that (dumb me) I made?
>
>Regards, and thanks.
>
>Melvin
As I understand it, when you run the initdb command you create the database with its systems tables and meta tables and the postmaster program, all of them being linked together by numeric keys that are randomly generated and specific to that release number. Just overwriting the /usr/lib/pgsql/data directory with the old copy won't do it. I don't think replacing the /usr/bin/postmaster with the old one will help either. Doing that, if it works, would only put you back to the previous release. But, if it did work you could then do pg_dump, etc... ? I'm betting that aside from using pg_dump to create scripts containing the database schema and data, your data is lost.
JLK
Nebraska Dept of Revenue