• Home
  • Services
    • DBA Support
    • DBA Consultancy Services
    • PostgreSQL Support
    • Website Maintenance
  • Courses

    About Courses

    • List Of Courses
    • Become an Instructor
    Greenplum Database

    Greenplum Database

    $2,000.00 $1,500.00
    Read More
  • Company
    • FAQs
    • About Us
    • Contact
  • Events
  • Portfolio
  • Blogs
    • Blog – RayaFeeL
    • Blog – PostgreSQL Support
    • Blog – PostgreSQL Migration
    • Blog – All DB’s
    • Blog – Linux
    • Blog – Medical Coding
      • Cart

        0

    Have any question?
    (+91)8838953252
    ITsupport@rayafeel.com
    RegisterLogin
    RayaFeeL
    • Home
    • Services
      • DBA Support
      • DBA Consultancy Services
      • PostgreSQL Support
      • Website Maintenance
    • Courses

      About Courses

      • List Of Courses
      • Become an Instructor
      Greenplum Database

      Greenplum Database

      $2,000.00 $1,500.00
      Read More
    • Company
      • FAQs
      • About Us
      • Contact
    • Events
    • Portfolio
    • Blogs
      • Blog – RayaFeeL
      • Blog – PostgreSQL Support
      • Blog – PostgreSQL Migration
      • Blog – All DB’s
      • Blog – Linux
      • Blog – Medical Coding
        • Cart

          0

      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 Cancel reply

      You must be logged in to post a comment.

      Login with:

      Login with Google Login with Twitter Login with LinkedIn Login with Microsoft


      Search

      ADVERTISEMENT

      Latest Posts

      PostgreSQL Patching version 9, 10,11
      10Oct2019
      Tools for PostgreSQL
      16Sep2019
      Postgres user creation and restrict DDL & database access
      13Sep2019
      PostgreSQL SSL Setup
      07Sep2019
      How to DELETE current XLOG / WAL LOG in postgresql database ?
      19Aug2019

      Latest Courses

      PostgreSQL Database

      PostgreSQL Database

      $600.00 $500.00
      Greenplum Database

      Greenplum Database

      $2,000.00 $1,500.00

      Preview Course

      Free

      Recent Forum Topics

      • thought behind whiteboard activity
      • Are you going to take your first ste
      • How to start working on an application?
      • please let me know pre requirements to increase work_mem
      • how to copy some data in one table to another table in postgres

      2ndquadrant.in

      (+91) 8838953252

      ITsupport@rayafeel.com

      Company

      • About Us
      • Contact
      • Our Team
      • Blog

      COURSES

      • List Of Course
      • Become An Instructor
      • Events
      • Postgres Support Blog

      Support

      • DBA Support
      • Consultancy Services
      • Postgres Migration Blogs
      • Forum

      Recommend

      • Groups
      • Login
      • FAQs
      • SignUp

      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

      Login with:

      Login with Google Login with Twitter Login with LinkedIn Login with Microsoft

      Login with your site account

      Lost your password?

      Not a member yet? Register now

      Register a new account

      Are you a member? Login now