On 15 Mar 2002 at 7:35, ananth rajaraman wrote: > I want to recover a postgres 6.5 database. all I have done is just > copied the <database> directory from the data/base directory of > posgres.
You did a good thing except that you may not have tarred it. I hope database was not running when you started copying things. > > Now I'm trying to recover it thro' the new version of postgres. > But I could not. Obviously you won't. Because the database file storage format is change with verion 7.x I believe. What you need to do is install postgres 6.5. Make sure that it's the exact version you used. Install an older distro. you have used earlier if required. And then do a pg_dump/pg_dumpall to a file. Use pg_restore to restore it from backup. In case you face any problems with copy, use insert statement, although it will make it much slower. man pg_dump for more details. > I'm also trying to install postgres 6.5 in RedHat Linux 7.1. But > this does not also work. Well. Not enough information to help you. But why you insist on 6.5? It's worth of an upgrade to 7.2 or whatever latest you get. Anyway your current setup is not working. HTH Shridhar _______________________________________________ linux-india-help mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/linux-india-help
