Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Postgresql question ??
Message
 
To
21/05/2002 19:46:05
Melvin Sequera
M&H New World, C.A.
Fuenlabrada, Spain
General information
Forum:
Linux
Category:
Internet Connection issues
Miscellaneous
Thread ID:
00659564
Message ID:
00659714
Views:
25
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform