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: "O'Dowd, Josh" <>, "" <>
  • Subject: [grouper-users] RE: Oracle to PostGRES migration strategy?
  • Date: Mon, 23 Jul 2018 17:06:55 +0000
  • Accept-language: en-US
  • Authentication-results: spf=none (sender IP is ) ;
  • Ironport-phdr: 9a23:dOgNjhYyDqslkix9TQm4pLX/LSx+4OfEezUN459isYplN5qZpsy4ZR7h7PlgxGXEQZ/co6odzbaO7ea4ASQp2tWoiDg6aptCVhsI2409vjcLJ4q7M3D9N+PgdCcgHc5PBxdP9nC/NlVJSo6lPwWB6nK94iQPFRrhKAF7Ovr6GpLIj8Swyuu+54Dfbx9HiTahYL5+Ngm6oRnMvcQKnIVuLbo8xAHUqXVSYeRWwm1oJVOXnxni48q74YBu/SdNtf8/7sBMSar1cbg2QrxeFzQmLns65Nb3uhnZTAuA/WUTX2MLmRdVGQfF7RX6XpDssivms+d2xSeXMdHqQb0yRD+v9LlgRgP2hygbNj456GDXhdJ2jKJHuxKquhhzz5fJbI2JKPZye6XQds4YS2VcRMZcTyxPDJ2hYYsTAeQPPuhYoIv8p1QSohSzHhOjCP/zxjJSmnP6wbM23uI8Gg/GxgwgGNcOvWzaoNv3NKYTUP66zLPQwT7ecf5W2S396InTchwvvPqBWrdwftbRyUgvFgLKkE+QpJfkPzOOyusBqXWb7/J+WuKpjW4rsR9+rSWyxso1jITCm4Ebykjc+Cln2ok5OcC0RUtmbdK5DZddsi+aOoRqTs8+Rmxlujg1x7IJtJO+eSUG1ogryh3HZ/CafYWE/gjvWeKMLTtimn5pZbayiwyv/UWiy+DwTse030hJoyZZl9TBs3MA2AHd6sWIT/Zw/Ums1iuV2A3W5OFIP085mKXeJpE9wbM/jIQfvELeFSHsgkr2lrWZdkA89+io9evnZrLmq4eEOYJojQ/yLroiltWiD+ogLwQCRm+b9v+i27H5+k35XalKgeYxkqnEtpDVON4XprajAw9SzoYs9QqwDyun0NQfm3kLNlVFeA+bj4jtPFHOJ/P4Ae2jjFSrlTdn3/HGPrv/DZXRNnXPjq3ucapg50NZ1QY/0M1T6pdaCrwOPP7/Rkr8ud7GARI2PAG5xuPqBMth2o4dQW6PB7WWMKLWsV+G/OIvJOyMaZcQuDnhK/gk5//vgmEjmVIGfKmpxocYZGqlHvR+PUqZZ3zsjs0fHmgXowoyVPbqh0GaUT5Pe3ayWLox5j4hCIKhEIfDXp6igKaY0CemBZ1ZeHpGCkuXHHfsdoWEQOsMaDmMLsN7kzwEU6ShRJE71RGoqgD616RrIvDK9SIFqJKwnORysqf02j016jAwR+aayGHHBzVWmXgIARh58KdgrWR40VDFzK1kxfFUCIoXr7lGSAAnLZPGivFhBsrpcgPHYtqTTlu6GJOrDSx7BoY+2dgTe0tnXsi5gwrY9yusH7IPkbGXXto5/r+KjFbrIMMogVbXxqQ7yxENQtFOLifu0qt09xnBCpThkl6S0buyeKIamiPB6THQniK1oEhEXVsoAu3+VncFax6T9IyhvBmQRqKyCbkhLgpKwNKDLa0PcNDykFFaX6m/as/GbTe3nGG9TVaTy7WAYZCiWl1V3T6VSS1m2xsW4W7AMAE/Aim7pGeLCTduBEDieWvt6uI4tWu2SElywg2XPAVs
  • Spamdiagnosticmetadata: NSPM
  • Spamdiagnosticoutput: 1:99

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…

 

Thanks

Chris

 

From: [mailto:] On Behalf Of O'Dowd, Josh
Sent: Friday, July 20, 2018 2:48 PM
To:
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