LinuxQuestions.org
LinuxAnswers - the LQ Linux tutorial section.
Go Back   LinuxQuestions.org > Forums > Linux > Linux - Software
Reload this Page converting a postgresql database to new version format
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices

Tags used in this thread
Popular LQ Tags , ,

Reply
 
Thread Tools
Old 08-03-2009, 05:23 PM   #1
rogerdv
LQ Newbie
 
Registered: Jul 2005
Location: Cuba
Distribution: redhat
Posts: 29
Thanked: 0
converting a postgresql database to new version format

[Log in to get rid of this advertisement]
After a reinstall, I lost my most recent backup in sql format and
instead I have the database directory. The big problem is that it is in
some old format, 8.1 doesnt accept it and 8.0.15 neither. Is there any
way to convert such database files to the recent format?
rogerdv is offline  
Tag This Post , ,
Reply With Quote
Old 08-05-2009, 02:22 AM   #2
chrism01
Guru
 
Registered: Aug 2004
Location: Brisbane
Distribution: Centos 5.4
Posts: 7,419
Thanked: 325
Sounds like you'll need the same version of Pg as they were created by.
chrism01 is offline     Reply With Quote

Reply

Bookmarks


Thread Tools

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 Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
PostgreSQL database design? justemail Linux - General 1 05-26-2009 09:27 AM
import database from postgesql 8.1 to postgresql 7.4 uxan Linux - General 3 05-19-2007 03:52 PM
LXer: Open Source Relational Database, PostgreSQL Version 8.1.1 Launches LXer Syndicated Linux News 0 12-30-2005 10:16 PM
Converting wma format to mp3 format. fakie_flip Linux - General 6 10-02-2005 08:49 PM
postgresql jdbc database server...????????? Sridhar Guntur Linux - Software 1 10-17-2002 03:42 PM


All times are GMT -5. The time now is 05:28 AM.

Contact Us - Advertising Info - Rules - LQ Merchandise - Donations - Contributing Member - LQ Sitemap - LinuxQuestions.org - Linux Forums
Main Menu
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
RSS2  LQ Podcast
RSS2  LQ Radio
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: @linuxquestions
Open Source Consulting | Domain Registration