[rt-users] RT upgrade problem ver 3.2.1. to 3.4.5

[himira ratnatilake]

I have tried to upgrade rt from 3.2.1 to 3.4.5 in a gentoo system. I
didn't change anything on the database. When I try to import the
previous db it gives so many errors. 
Then I remove the db and directly import the db. Then rt doesn't work 
correctly it gives error like  
-----------------------------------------------------------------------
DBD::Pg::st execute failed: ERROR:  permission denied for relation users
RT::Handle=HASH(0x9111ba8) couldn't execute the query 'SELECT  * FROM
Users WHERE LOWER(Name) = LOWER(?)'
at /usr/lib/perl5/vendor_perl/5.8.6/DBIx/SearchBuilder/Handle.pm line
506

DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0x9111ba8)',
'SELECT  * FROM Users WHERE LOWER(Name) = LOWER(?)', 'RT_System') called
at /usr/lib/perl5/vendor_perl/5.8.6/DBIx/SearchBuilder/Record.pm line
1218

DBIx::SearchBuilder::Record::_LoadFromSQL('RT::CurrentUser=HASH(0x9743bf4)', 'SELECT  * FROM Users WHERE LOWER(Name) = LOWER(?)', 'RT_System') called at /usr/lib/perl5/vendor_perl/5.8.6/DBIx/SearchBuilder/Record.pm line 1133

DBIx::SearchBuilder::Record::LoadByCols('RT::CurrentUser=HASH(0x9743bf4)', 'LOWER(Name)', 'HASH(0x9189818)') called at /usr/lib/perl5/vendor_perl/5.8.6/DBIx/SearchBuilder/Record/Cachable.pm line 137

DBIx::SearchBuilder::Record::Cachable::LoadByCols('RT::CurrentUser=HASH(0x9743bf4)', 'LOWER(Name)', 'HASH(0x9189818)') called at //usr/share/webapps/rt/3.4.5/hostroot/rt-3.4.5/lib/RT/Record.pm line 392
        RT::Record::LoadByCols('RT::CurrentUser=HASH(0x9743bf4)',
'Name', 'RT_System') called
at /usr/lib/perl5/vendor_perl/5.8.6/DBIx/SearchBuilder/Record.pm line
1078

DBIx::SearchBuilder::Record::LoadByCol('RT::CurrentUser=HASH(0x9743bf4)', 'Name', 'RT_System') called at //usr/share/webapps/rt/3.4.5/hostroot/rt-3.4.5/lib/RT/CurrentUser.pm line 254
        RT::CurrentUser::LoadByName('RT::CurrentUser=HASH(0x9743bf4)',
'RT_System') called
at //usr/share/webapps/rt/3.4.5/hostroot/rt-3.4.5/lib/RT.pm line 153
        RT::Init() called
at /var/www/localhost/rt/rt-3.4.5/bin/webmux.pl line 119
        RT::Mason::handler('Apache2::RequestRec=SCALAR(0x9111698)')
called at -e line 0
        eval {...} called at -e line 0
DBD::Pg::st execute failed: ERROR:  permission denied for relation users
RT::Handle=HASH(0x9111ba8) couldn't execute the query 'SELECT  * FROM
Users WHERE LOWER(Name) = LOWER(?)'
at /usr/lib/perl5/vendor_perl/5.8.6/DBIx/SearchBuilder/Handle.pm line
506

DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0x9111ba8)',
'SELECT  * FROM Users WHERE LOWER(Name) = LOWER(?)', 'Nobody') called
at /usr/lib/perl5/vendor_perl/5.8.6/DBIx/SearchBuilder/Record.pm line
1218

DBIx::SearchBuilder::Record::_LoadFromSQL('RT::CurrentUser=HASH(0x97540b8)', 'SELECT  * FROM Users WHERE LOWER(Name) = LOWER(?)', 'Nobody') called at /usr/lib/perl5/vendor_perl/5.8.6/DBIx/SearchBuilder/Record.pm line 1133

DBIx::SearchBuilder::Record::LoadByCols('RT::CurrentUser=HASH(0x97540b8)', 'LOWER(Name)', 'HASH(0x97547f0)') called at /usr/lib/perl5/vendor_perl/5.8.6/DBIx/SearchBuilder/Record/Cachable.pm line 137

DBIx::SearchBuilder::Record::Cachable::LoadByCols('RT::CurrentUser=HASH(0x97540b8)', 'LOWER(Name)', 'HASH(0x97547f0)') called at //usr/share/webapps/rt/3.4.5/hostroot/rt-3.4.5/lib/RT/Record.pm line 392
        RT::Record::LoadByCols('RT::CurrentUser=HASH(0x97540b8)',
'Name', 'Nobody') called
at /usr/lib/perl5/vendor_perl/5.8.6/DBIx/SearchBuilder/Record.pm line
1078

DBIx::SearchBuilder::Record::LoadByCol('RT::CurrentUser=HASH(0x97540b8)', 'Name', 'Nobody') called at //usr/share/webapps/rt/3.4.5/hostroot/rt-3.4.5/lib/RT/CurrentUser.pm line 254
        RT::CurrentUser::LoadByName('RT::CurrentUser=HASH(0x97540b8)',
'Nobody') called
at //usr/share/webapps/rt/3.4.5/hostroot/rt-3.4.5/lib/RT.pm line 157
        RT::Init() called
at /var/www/localhost/rt/rt-3.4.5/bin/webmux.pl line 119
        RT::Mason::handler('Apache2::RequestRec=SCALAR(0x9111698)')
called at -e line 0
        eval {...} called at -e line 0

---------------------------------------------------------------------------

Do I need to change the scheme/db/parameter when upgrading.
How do I correctly migrate the db??

/himira. 





CONFIDENTIALITY NOTICE The information contained in this message is
confidential, intended only for the use of the individual or the entity
named as recipient. If the reader of this message is not that recipient,
you are notified that any dissemination, distribution or copy of this
message is strictly prohibited. If you have received this message in
error, please immediately notify us by telephone on the number above.
Your co-operation is appreciated.