LinuxQuestions.org
LinuxAnswers - the LQ Linux tutorial section.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - General
User Name
Password
Linux - General This 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



Reply
 
Search this Thread
Old 05-18-2007, 09:29 AM   #1
uxan
Member
 
Registered: Jun 2006
Location: Rwanda, Kigali
Distribution: Fedora core
Posts: 60

Rep: Reputation: 15
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
 
Old 05-18-2007, 05:06 PM   #2
Tinkster
Moderator
 
Registered: Apr 2002
Location: in a fallen world
Distribution: slackware by choice, others too :} ... android.
Posts: 23,005
Blog Entries: 11

Rep: Reputation: 903Reputation: 903Reputation: 903Reputation: 903Reputation: 903Reputation: 903Reputation: 903Reputation: 903
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
 
Old 05-19-2007, 05:51 AM   #3
uxan
Member
 
Registered: Jun 2006
Location: Rwanda, Kigali
Distribution: Fedora core
Posts: 60

Original Poster
Rep: Reputation: 15
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
 
Old 05-19-2007, 03:52 PM   #4
Tinkster
Moderator
 
Registered: Apr 2002
Location: in a fallen world
Distribution: slackware by choice, others too :} ... android.
Posts: 23,005
Blog Entries: 11

Rep: Reputation: 903Reputation: 903Reputation: 903Reputation: 903Reputation: 903Reputation: 903Reputation: 903Reputation: 903
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
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
MySQL Database Import ballistic509 Linux - Server 4 03-31-2007 02:26 AM
MYSQL Database Import Behrooz_Ice Linux - General 2 09-08-2006 05:15 AM
MySQL Database Import sbb Linux - Software 1 06-04-2006 12:15 PM
MySQL import database akines Linux - Software 3 04-19-2006 02:14 AM
How to import a mysql database from backup WindowBreaker Slackware 6 03-17-2006 12:08 AM


All times are GMT -5. The time now is 04:40 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration