Skip to Content.
Sympa Menu

grouper-users - [grouper-users] Re: Oracle to PostGRES migration strategy?

Subject: Grouper Users - Open Discussion List

List archive

[grouper-users] Re: Oracle to PostGRES migration strategy?

Chronological Thread 
  • From: "Hyzer, Chris" <>
  • To: "Black, Carey M." <>
  • Cc: "" <>
  • Subject: [grouper-users] Re: Oracle to PostGRES migration strategy?
  • Date: Tue, 24 Jul 2018 15:30:54 +0000
  • Accept-language: en-US
  • Authentication-results: spf=none (sender IP is ) ;
  • Ironport-phdr: 9a23:VS7AsBU3MZLAiWEV2q2FMJURlynV8LGtZVwlr6E/grcLSJyIuqrYbRGCt8tkgFKBZ4jH8fUM07OQ7/i+HzRYqb+681k6OKRWUBEEjchE1ycBO+WiTXPBEfjxciYhF95DXlI2t1uyMExSBdqsLwaK+i764jEdAAjwOhRoLerpBIHSk9631+ev8JHPfglEnjWwba9zIRmssQndqtQdjJd/JKo21hbHuGZDdf5MxWNvK1KTnhL86dm18ZV+7SleuO8v+tBZX6nicKs2UbJXDDI9M2Ao/8LrrgXMTRGO5nQHTGoblAdDDhXf4xH7WpfxtTb6tvZ41SKHM8D6Uaw4VDK/5KpwVhTmlDkIOCI48GHPi8x/kqRboA66pxdix4LYeZyZOOZicq/Ye94RWGhPUdtLVyFZAo2ycZYBD/YPM+hboYnypVoOogexCgS3Huzj1iNEi2Xq0aEm0+ksFxzN0gw6H9IJtXTZtNv5OqUSUOG00qbI1y3PZO5I1Df98ojIcwshrf+RVr93dMre1UkvFgPEj1qOs4zoJDKV1v8RvGSB8upgTfygi2ghqw1rvDeg29osh5DPi4kIyV7E7T10zJgvKtGkVUJ2ZMOoHIZNuyyfOYt7Td8uT31ttSs41LILuYK3cS0PxZg52xLSauSLfoeU7h75V+udPS10iGx7dL6hnRq+7Eetx+7kWsm6zllHrTZJn9zJu30OyhPT5MeKR/5+80qvxDmAzQXe6u9aLU07mqfWLoIuz70qmZYNt0nIAzX4l1/sjKCMc0Up4uio5PrjYrXhvpKSL5N5hAbiPqkug8CyH/02PhUXU2ic4uuzyqfv/UrkQLVWlfI2lbTZsJbHKsgBvq65GQhV0po95BmjEzem0dMYnX8dIFJCZRKHk4zpO1bJIPD7F/uwn1OskDJzy/DHOL3uHInNI2DdnLj7Ybpx9ktRxBcuwdxC4p9UBL4MLO7vVkL0ttHXEB80PxCxzuviFtlxyoITVXqKAqCDMaPStVGI5vgoI+mJfIIVvSryK/gl5v/vk3A5g0QQfaiy3ZQLcny4A+xmLFufYXrqmNsOD3oFvhcmQOzwlFKCSSJTZ2q1X68k6TE7EoWmDZrbRo+zmryNxTq7HoZIaWBcEVCBCnPod4SfW/cQcyKePNVtkj0CVbi9VYAhzxeuuxHmy7Z5NObb5DAXtY+wnORysqf5kRg59ng8JM2H3nDFaic+1jcCQzY93+Ym+xdVzUyel6V0nqoLO8ZU4qYDchYoOISYh8d6EdHpEEqVe9yJWUSrWP2nGjp3U8o8xdlIbkpgTYbxxivf1janVudG34eAA4Y5p+eFhyCrfZR01mrG2a89jlIvXspIMyi8i7Vi8xTIWdKbiF2XwqCtc6lUnDXA8muO1yKvhAlZS0YxNMeNRnUDfg3TpNX96FnFSuqrArQ2IAZb4c+ZIe1XctDvixNLSOqwcNk=
  • Spamdiagnosticmetadata: NSPM
  • Spamdiagnosticoutput: 1:99

If I recall correctly the export/import does not do point in time.  If you find a dB migration tool it would obviously.   The sync to another grouper is intended for a few groups memberships not to sync an entire registry.

Chris Hyzer
Application Architect
PennGroups, Two-step, NGSS Security

From: Black, Carey M. <>
Sent: Monday, July 23, 2018 1:43:48 PM
To: Hyzer, Chris
Subject: RE: Oracle to PostGRES migration strategy?



I am also looking at “switching DBs”. ( In my case: MYSQL to Oracle.) So I tend to think this kind of thing happens from time to time with existing installs. Given the possible “move to the cloud” conditions I can also image the frequency increasing.




With the export/import option….


                How is point in time data handled?

                Would you leave that information behind?


If one was to set up a “grouper (Oracle) to grouper (PostGRES)” integration would that be the same idea, only in real time?

                (The architectural diagram describes it as an “XMPP/HTTPS” integration to “Another grouper”. )

                And again… How is point in time data handled?



Carey Matthew


From: <> On Behalf Of Hyzer, Chris
Sent: Monday, July 23, 2018 1:07 PM
To: O'Dowd, Josh <>;
Subject: [grouper-users] RE: Oracle to PostGRES migration strategy?


Would be nice if you could create the tables in postgres with GSH.  Empty the tables completely, turn off constraints, and migrate the data from oracle to postgres, turn on constraints and good to go.


If you do export/import it is slow for large registries, might have some issues, and doesn’t do all the tables I believe, but should get you generally there and you can let us know if there are problems…





From: [] On Behalf Of O'Dowd, Josh
Sent: Friday, July 20, 2018 2:48 PM
Subject: [grouper-users] Oracle to PostGRES migration strategy?


Is there a “right” way to move Grouper 2.3.0 registry data from Oracle to PostGRES, or simply one database flavor to another?  Thanks.


Josh O’Dowd

Software Systems Engineer / Identity Access Management

University of Montana


Archive powered by MHonArc 2.6.19.

Top of Page