[rt-users] How to move an existing database to a new server

[William Clarke]

Vas,

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 
database
password, just press return.

Password:
Working with:
Type:   Pg
Host:   localhost
Port:
Name:   rt4
User:   rt_user
DBA:    root
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------


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 : )

William Clarke
ITS System Administrator
Bard College at Simon's Rock
84 Alford Road
Great Barrington, MA  01230
(413) 528-7428 (voice)
(413) 528-7405 (fax)
wclarke at simons-rock.edu

On 10/21/2014 5:01 AM, Vas wrote:
> Hi all,
> I am trying to move an existing RT database (3.8.11) to a new server running
> 4.0.4.
> I have succesfully done a dump and scp and imported the database on the new
> server.
> 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.
>
> Thank you
> Vas
>
>
>
> --
> 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.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20141021/060916ef/attachment.htm>