From: <wj...@pa...> - 2009-04-15 18:57:53
|
I am attempting to upgrade 2.6.1 database(PG 7.3) to version 2.8.24(with PG 8.3). Created new empty dataset "db_new_2.8.24", Fixed SETVAL etc as per FAQ in old database "db_old_2.6_1" then restore with psql db_new_2.8.24.sql < db_old_2.6_1.sql BUT getting scores of errors "relation xyz etc does not exist". I also tried fixing all the tables by putting "WITH OIDS" in db_old_2.6_1.sql but that does not work either (the inserts now appeared to work but getting same errors at the end - maybe INDEXES may be an issue) Any suggestions anyone? Thanks and regards |