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?

Please help me

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.


Cheers,
Tink

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?

Please help me

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?


Cheers,
Tink