Not being familiar with Ubuntu so I don’t know where your rt4 install
directory is but on CentOS\RHEL it would be /opt/rt4 so I would run
something like this: “/opt/rt4/sbin/rt-setup-database --action upgrade”
I had a database from rt 3.8.6 build and similarly did a dump \ restore
to rt 4.2.8 build. When running above command it asked me what version
am I upgrading from and it ran the necessary updates. After running the
upgrade command did you see something like the following:
In order to create or update your RT database, this script needs to
connect to your Pg instance on localhost (port ‘’) as root
Please specify that user’s database password below. If the user has no
password, just press return.
Try setting your LogLevel to debug. I’m sure it will provide some
helpful info. If you pass it along I’m confident somebody from the list
can provide further assistance besides a RT newbie like myself : )
ITS System Administrator
Bard College at Simon’s Rock
84 Alford Road
Great Barrington, MA 01230
(413) 528-7428 (voice)
(413) 528-7405 (fax)
email@example.comOn 10/21/2014 5:01 AM, Vas wrote:
I am trying to move an existing RT database (3.8.11) to a new server running
I have succesfully done a dump and scp and imported the database on the new
When I log in to RT via the browser I can see the database but when I try to
take a ticket I get the following error- Could not change owner: Couldn’t
add member to group
Which I am assuming means that the database is actually not connected or
something else needs to happen in the back end for it to work.
I am using Ubuntu server 12.04.5 LTS on a vm machine.
I do have a snapshot of the new server prior to importing the old database
if other steps are required first prior to importing.
I would be most grateful for any input.
Having searched around on the internet I did try rt-setup-database --schema
and upgrade with no result.
View this message in context:http://requesttracker.8502.n7.nabble.com/How-to-move-an-existing-database-to-a-new-server-tp58875.html
Sent from the Request Tracker - User mailing list archive at Nabble.com.