import database from postgesql 8.1 to postgresql 7.4
Linux - GeneralThis Linux forum is for general Linux questions and discussion.
If it is Linux Related and doesn't seem to fit in any other forum then this is the place.
Notices
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
import database from postgesql 8.1 to postgresql 7.4
Hello,
I have a problem, i want to import a database from postgresql 8.1 installed in fedora core 6 to postgresql 7.4 installed in fedora core 3.
How can i procced?
Why don't you just upgrade the old version (or in fact upgrade
*both* to 8.2.4)?
Basically you'd need to pg_dump all tables individually,
and then check for features that 7.x doesn't support and
remove them. But that's very cumbersome, I wouldn't try
it if I were you.
import database from postgesql 8.1 to postgresql 7.4
Hi,
I don't have any choice because my situation forces me to return to the old version.So, tell me what kind of features can i remove ?, am i have to pg_dump every table ? there is no another way to dump the whole database?
I can't tell you what you can't take across because I don't
know your database layout. You *can*, however, just do the
pg_dumpall and see where it fails on import, remove, retry,
repeat. Best of luck.
Why can't you update, or even need to go to an older version?
If it's a Fudora related problem, just install Postgres from source?
LinuxQuestions.org is looking for people interested in writing
Editorials, Articles, Reviews, and more. If you'd like to contribute
content, let us know.
