To be clear, essentially this is what happened. I backed up web2py folder, and postgres database separately. Then, I upgraded the os, including postgres to version 8.4. After that, I unzipped the web2py folder and installed the database.
And I have this problem. This is quite frustrating. Here's part of the ticket. Any help is greatly appreciated. THANKS. File "/home/user/web2py/gluon/tools.py", line 1177, in define_tables format='%(first_name)s %(last_name)s (%(id)s)') File "/home/user/web2py/gluon/dal.py", line 3884, in define_table polymodel=polymodel) File "/home/user/web2py/gluon/dal.py", line 581, in create_table self.create_sequence_and_triggers(query,table) File "/home/user/web2py/gluon/dal.py", line 1575, in create_sequence_and_triggers self.execute(query) File "/home/user/web2py/gluon/dal.py", line 1137, in execute return self.log_execute(*a, **b) File "/home/user/web2py/gluon/dal.py", line 1134, in log_execute return self.cursor.execute(*a,**b) ProgrammingError: relation "auth_user" already exists