• Home
  • Services
    • HR Services
      • HR Advisory Services
      • Contract Staffing
      • HR Outsourcing Services
      • Manpower Supply Services
      • Payroll Processing
      • Permanent Placement
      • Recruitment and Placement Services
      • Recruitment Process Outsourcing
      • Staffing Agency Services
    • DBA Support
      • DBA Consultancy Services
      • PostgreSQL Support
    • Website Maintenance
    • Company Registration Services
    • Virtual Office Space Address
  • Company
    • FAQs
    • About Us
    • Contact
  • Locations
  • Blogs
    • Blog
    • Blog – PostgreSQL Support
    • Blog – PostgreSQL Migration
    • Blog – All DB’s
    • Blog – Linux
  • Courses

    About Courses

    • List Of Courses
    • Become an Instructor
    Greenplum

    Greenplum

    $1,500.00
    Read More
    Have any question?
    (+91)8838953252
    ITsupport@rayafeel.com
    Login
    RayaFeeL
    • Home
    • Services
      • HR Services
        • HR Advisory Services
        • Contract Staffing
        • HR Outsourcing Services
        • Manpower Supply Services
        • Payroll Processing
        • Permanent Placement
        • Recruitment and Placement Services
        • Recruitment Process Outsourcing
        • Staffing Agency Services
      • DBA Support
        • DBA Consultancy Services
        • PostgreSQL Support
      • Website Maintenance
      • Company Registration Services
      • Virtual Office Space Address
    • Company
      • FAQs
      • About Us
      • Contact
    • Locations
    • Blogs
      • Blog
      • Blog – PostgreSQL Support
      • Blog – PostgreSQL Migration
      • Blog – All DB’s
      • Blog – Linux
    • Courses

      About Courses

      • List Of Courses
      • Become an Instructor
      Greenplum

      Greenplum

      $1,500.00
      Read More

      Blog

      • Home
      • Blog
      • Blog
      • Some Clarification of Oracle Exa Data to postgreSQL GIS Data Migration

      Some Clarification of Oracle Exa Data to postgreSQL GIS Data Migration

      • Posted by 2ndnijam
      • Categories Blog
      • Date November 24, 2018
      • Comments 0 comment

        1.  We need to offer a high available architecture for the Postgre layer. (clustered, active active, replication… etc.)

      We can choose any one of the High Availability Architecture approach

      1. a)      High availability in PostgreSQL DB  by using Rep Manager
      2. b)      High availability in virtual IPs
      3. c)      Streaming Replication and automatic failover in two nodes (AWS Could server)

      High availability architecture by using Virtual IP

      1 Multiple health checks for master & standby nodes

      2 Automatic failover from master to standby node

      3 Controlled switchovers for planned events on master

      4 Support for multiple streaming replication

       

        2.  We need to offer backup infrastructure and tools

      We can choose any one of the backup approach.  

      1. a)      Barman is open source tool for backup and restore
      2. b)      We will take the backup by using the Linux script (Automatic Backup CRONJOB)

       

        3.  we need to offer monitoring infrastructure and tools

      We can choose any one of the open source monitoring tools

      1. a)      Grafana database monitoring tool
      2. b)      pgAdmin4 database monitoring tool
      3. c)      pghero database monitoring tool

      Grafana database dashboard view sample screen

      1. d)       Grafana Disk Usage screen for memory

                    Pgadmin4  dashboard sample view screen for monitoring

                                                                          

      4.We need to offer standby infrastructure

      Could you please give me clarity on this question?

      The two Oracle databases entirely spatial and for the POC we are going to migrate to Postgre to server ArcGIS. They already have a migration documentation; please check this URL:http://desktop.arcgis.com/en/arcmap/10.3/manage-data/gdbs-in-oracle/data-migration.html

      5. You can work on ArcGIS for determining how to migrate these Geometry_storage and Raster_Storage. If we don’t know how to migrate ArcGIS we are going to have a lot of troubles in the project.

      1. a)      We will support geodatabase(geographic information) data for migration
      2. b)      We need to configure the setting in our target and source databases
      3. c)      We can support the client all areas.

      6.   We  need to decide on in which step we are going to use to which tool. Ora2Pg,  Migration Toolkit Tool or ESRI Migrate Storage (http://desktop.arcgis.com/en/arcmap/10.3/tools/data-management-toolbox/migrate-storage.htm)

      We can choose any one of the tools for migration

      1. a)      Ora2pg open source
      2. b)      Migration Toolkit commercial

      7.   Have you tried to migrate from Plugabble Oracle DB to PostgreDB?

      Yes

      Contact Us For Migration

       

      • Share:
      2ndnijam

      Previous post

      Best PostgreSQL Corporate Training Team from RayFeeL
      November 24, 2018

      Next post

      PostgreSQL Replication Setup / configuration on Linux
      November 25, 2018

      Leave A Reply

      You must be logged in to post a comment.

      Connect with



      Search

      ADVERTISEMENT

      Latest Posts

      Tips to Choose the Best Serviced Office for Your Business
      24May2022
      What key considerations do you need to keep in mind when choosing a new serviced office to house your business?
      24May2022
      The Benefits of Coworking
      24May2022
      The Long-Term Impact of Coworking
      24May2022
      Are you spending more money than you earn? Outsource with Ease and Move When You’re Ready
      24May2022
      PostgreSQL

      PostgreSQL

      $800.00 $500.00
      Greenplum

      Greenplum

      $1,500.00
      Oracle Database

      Oracle Database

      $350.00
      2ndquadrant.in

      (+91) 8838953252

      ITsupport@rayafeel.com

      Company

      • About Us
      • Our Team

      COURSES

      • List Of Course
      • Become An Instructor

      Support

      • DBA Support
      • Consultancy Services

      Recommend

      • Login
      • Contact Us

      IT Services by rayafeel.com. Powered by Rayafeel Technologies Pvt Ltd.

      • Privacy
      • Terms

      Become An Instructor?

      Join thousand of instructors and earn money hassle free!

      Get Started Now

      Connect with

      Login with Google Login with Twitter Login with Linkedin Login with Windowslive Login with Yahoo

      Login with your site account

      Connect with



      Lost your password?