[Rt-devel] Error in rt-setup-database with pgsql 8.1

Angelo Turetta aturetta+rt at bestunion.it
Wed Nov 22 13:39:14 EST 2006


I'm installing rt3.6.1 on FreeBSD 6-STABLE, and I found a strange 
behaviour regarding database creation on postgresql.

I have two different PostgreSQL servers, one 8.0.8 and the other 8.1.5. 
Both servers already contain one or more RT database (used by other 
RT-3.4.x test instances) and both servers already have the default 
rt_user login.

The 3.6.1 test instance is configured to access a database called rt36 
(that does not exist in any of the servers). I use the command

    rt-setup-database --force --action init

if I tell RT to use the 8.0x server, init works well.
==================================== output against 8.0x
Now creating a database for RT.
Creating Pg database rt36.
Now populating database schema.
Creating database schema.
readline() on closed filehandle SCHEMA_LOCAL at 
/usr/local/rt3/sbin/rt-setup-database line 192.
Done setting up database schema.
Now inserting database ACLs
Done setting up database ACLs.
Now inserting RT core system objects
Checking for existing system user...not found.  This appears to be a new 
installation.
Creating system user...done.
Now inserting RT data
   (.....)
=======================================

If I try with the 8.1x server, I get the following:
==================================== output against 8.1x
Now creating a database for RT.
Creating Pg database rt36.
Now populating database schema.
Creating database schema.
readline() on closed filehandle SCHEMA_LOCAL at 
/usr/local/rt3/sbin/rt-setup-database line 192.
Done setting up database schema.
Now inserting database ACLs
DBD::Pg::st execute failed: ERROR:  role "rt_user" cannot be dropped 
because some objects depend on it
DETAIL:  41 objects in database rtcommit
Problem with statement:
  drop user rt_user;
ERROR:  role "rt_user" cannot be dropped because some objects depend on it
DETAIL:  41 objects in database rtcommit
*** Error code 255 (ignored)
=======================================

The test WEB server I'm using has PostgreSql client 8.1.5 installed.

Is there a way to ignore the error in "drop user rt_user;" ?

Hope I explained the case well enough.
Angelo.


More information about the Rt-devel mailing list