From: <wj...@pa...> - 2009-04-16 03:27:04
|
Further to below mail I managed to get a bit further but am now getting following error as soon as I try to login to the now updated (I think!) dataset: Error! SELECT * FROM defaults ERROR: permission denied for relation defaults. Quite puzzled as to what is going on. 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 < 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 |