Spent some more time on this over the last couple of days, but still not a lot of progress, just error messages.
Having cleared out any remnants of previous tests using drop database rtdb; and drop role rtuser;, I followed the latest set of instructions. I created the database using rt-setup-database-4 --action create --dba postgres which seems fine. I then try to import the dumped data file (created with the -x switch of pg_dump),a nd it gives me the following error after every CREATE command ... CREATE TABLE psql:/home/gmason/rtdb-20130425.sql:53: ERROR: role "rtuser" does not exist CREATE SEQUENCE psql:/home/gmason/rtdb-20130425.sql:66: ERROR: role "rtuser" does not exist So I try and create the rtdb role using create role rtdb; and give it login attributes and then try the import again, having first dropped the database first.The import seems to work fine, with no errors, so I continue to the next stage as instructed, which is setting up the acl's. # rt-setup-database-4 --action acl --dba postgres Working with: Type: Pg Host: localhost Name: rtdb User: rtuser DBA: postgres Now inserting database ACLs. DBD::Pg::st execute failed: ERROR: relation "classes_id_seq" does not exist at /usr/share/request-tracker4/lib/RT/Handle.pm line 439, <STDIN> line 1. DBD::Pg::st execute failed: ERROR: relation "classes_id_seq" does not exist at /usr/share/request-tracker4/lib/RT/Handle.pm line 439, <STDIN> line 1. So I'm now stumped as to how to actually get anywhere. In case it makes any difference, I am running the rt-setup-database-4 commands as the root user, but importing the data dump file as the postgres user. Can someone put me out of my misery ?? -- View this message in context: http://requesttracker.8502.n7.nabble.com/Problems-upgrading-from-3-9-3-tp53543p53710.html Sent from the Request Tracker - User mailing list archive at Nabble.com.
