Grouper Users - Open Discussion List

[Jim Fox <>]

The test 1.6 database is a copy of my production system (v1.6).
I ran the 'gsh -registry -check' on it.  The resulting sql file
can be found at:

   http://urizen4.cac.washington.edu/grouperDdl_20120604_11_09_36_938.sql.txt


I am using postgres.  My hybernate properties has

  hibernate.connection.url = jdbc:postgresql://localhost/gws1dev
  hibernate.dialect =
  hibernate.connection.driver_class =
   (those are the autodetect options)

Jim



On Mon, 4 Jun 2012, Shilen Patel wrote:

> Date: Mon, 4 Jun 2012 13:14:20 -0700
> From: Shilen Patel 
> <>
> To: Jim Fox 
> <>,
>     grouper users list 
> <>
> Subject: Re: [grouper-users] upgrade 1.6 to 2.1
>
> The upgrade should take care of populating those table.  If you want to
> send me your upgrade script and let me know what type of database you're
> running (postgres?), I can take a look at what's wrong.
>
> Thanks!
>
> -- Shilen
>
>
> On 6/4/12 3:57 PM, "Jim Fox" 
> <>
>  wrote:
>
> > When I did a test upgrade of 1.6 to 1.7 (when the pit tables were added)
> > the conversion sql script had entries like these:
> >
> >    drop table grouper_flat_memberships cascade;
> >    drop table grouper_flat_groups cascade;
> >    drop table grouper_flat_stems cascade;
> >    drop table grouper_flat_attribute_def cascade;
> >
> >    insert into grouper_pit_fields ...
> >    insert into grouper_pit_stems ...
> >    ...
> >
> >
> > When I try a conversion of a test 1.6 to 2.1 I don't see those entries.
> > My 1.6 DB has the flat tables and does not have the pit tables.
> >
> > Is there another way the tables are being populated nowadays?
> >
> > Jim