[rt-users] Problems upgrading from 3.9.3

[Thomas Sibley]

On 04/24/2013 04:06 AM, saxmad wrote:
> After a lot of trial and error, I think I have worked out what is going on.
> 
> With a clean postgres database, I cannot import my dump file due to the
> rtuser role not being there.
> 
> So I initialised the database by running the rt-setup-database-4 --action
> init utility to put that right.  Unfortunately, part of this seems to be
> setting up the initial core data, which looks like it includes the acl
> table.

You can have RT setup the database user and create the database by using:

    rt-setup-database-4 --action create,acl

The "init" action is the same as "make initdb" which is the whole
process for a new install.

When you restore, you'll still need to tell "psql" what database you're
importing into (presumably "rtdb").