I have a old db running version 7.2.2 on linux and am in the process of updating the install to a windows xp box. I want to use the latest db version ( 8.1.3) and am having difficulty figuring out how to copy my data from the old one to the other. I tried the pg_dump tool which i used in the past to copy data from one 7.2.2 installation to another 7.2.2 installtion on linux and it worked just fine but when i try it now using the pg_restore utility it gives me errors saying the format is wrong. Can anyone provide me with the proper instructions to accompilsh this?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Migrating data from 7,2,2 on linux to 8.1.3 on windows
- Thread starter malukalu
- Start date
There was a post somewhat similar to your issue. In that case, it was a database encoding problem. Try troubleshooting the problem in smaller pieces of your database. Like, start out with a couple of tables and data.
Hope that helps,
Gary
gwinn7
Hope that helps,
Gary
gwinn7
- Status
Similar threads
- Locked
- Question
- Locked
- Question