Giter Club home page Giter Club logo

experdb-management's Introduction

eXperDB-Management

eXperDB and PostgreSQL Management Tool

Introduction

eXperDB-Management is a PostgreSQL management tool(for efficient operation and management). Use backup settings and periodic scheduling to prepare for system failures, grant access to the system, and view backup and access control history. It also provides data encryption for information protection.

Dashboard

Features

  • Backup
    • Full backup, Incremental backup, Other backups with the pg_dump options
  • Restore
    • Emergency restore, Point-in-Time Restore, pg_dump restore
  • Access control
    • Access control settings based on pg_hba.conf and audit
  • Scheduling
    • Schedule for tasks that need to be done on a regular basis
  • Data transmission
    • Real-time data transfer from PostgreSQL to HDFS
  • Data Encryption
    • Data Encryption for Information Protection
    • Encryption key automatic management function according to Auto Scale-Out/In
  • Multiple Languages Support
    • Korean, English
  • Auto Scaling(On AWS)
    • Auto Scale-Out/In function according to threshold setting On public cloud(AWS)
    • Automatic and manual management

TODO

  • Supports PostgreSQL Version 12

License

LICENSE

Getting Started

Installation

System Requirements

  • OS : Developed and tested on Linux and Windows, but work on any UNIX-like system and Windows System
  • JDK : JDK 1.7 or later
  • CPU : At least 4core, recommended 8core
  • HDD : 100GB or more
  • WAS : Apache-Tomcat

Components

  • eXperDB-Management-Agent
  • eXperDB-Management-WebConsole
  • eXperDB-Management Repository Database

1. Installing eXperDB-Management-Agent

1-1. Install agent using eXperDB-Management-Agent-10.7.1.0.run file

1-2-1. Upload to installation target server using FTP program  
1-2-2. Run eXperDB-Management-Agent-10.7.1.0.run file  
1-2-3. cd eXperDB-Management-Agent/bin    
1-2-4. chmod 755 agent_setup.sh   
1-2-5. ./agent_setup.sh    
1-2-6. Enter information (DBMS IP, Port, Default Database, Username, password, Agent IP, Agent Port)       

1-3. Starting and stopping the agent

1-3-1. Start : experDB-Management-Agent/bin/startup.sh   
1-3-2. stop : experDB-Management-Agent/bin/stop.sh

2. Installing eXperDB-Management-WebConsole

2-1. Install agent using eXperDB-Management-WebConsole-10.7.1.0.run file

2-2-1. Upload to installation target server using FTP program  
2-2-2. Run eXperDB-Management-WebConsole-10.7.1.0.run file  
2-2-3. cd eXperDB-Management-WebConsole/webapps/eXperDB-Management-WebConsole/WEB-INF/classes    
2-2-4. chmod 755 webConsole_setup.sh  
2-2-5. ./webConsole_setup.sh    
2-2-6. Enter information (DBMS IP, Port, Default Database, Username, password)       

2-3. Starting and stopping the agent

2-3-1. Start : eXperDB-Management-WebConsole/bin/start.sh   
2-3-2. Stop : eXperDB-Management-WebConsole/bin/shutdown.sh  

Appendix

1. Installation eXperDB-Trnasfer(for Data Transfer)

Contribution

If you find a bug, please report to us by posting issues on Github.
Source code modifications via pull requests are welcome.
Also, if you would like to contact us directly, please send an email to [email protected]. (develop branch)

Copyright

Copyright (c) 2016-2020, eXperDB Development Team All rights reserved.

Community

experdb-management's People

Contributors

20hyun avatar dependabot[bot] avatar gogoickgick avatar jeon0je avatar jeong-yoon avatar jinyyoon avatar joo01224 avatar jungjw96 avatar kayform avatar ksjj97inzent avatar mj-kim0210 avatar mjkim0210 avatar net6825 avatar oppasw avatar parks007net avatar swbyun avatar tcc02349 avatar xperdb avatar yeeun0514 avatar yongwoolee avatar yyura avatar

Stargazers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

Watchers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

experdb-management's Issues

저장시 200오류 발생

Admin/메뉴권한관리
저장은 정상적으로 동작하나 저장 클릭 시 오류창 발생 (ERROR CODE : 200 ....... Unexcepted end of JSON input)
확인 부탁드립니다.

database관리 설정 오류

Admin/database관리
database관리에서 관리버튼클릭하여 정보수정시 설명등의 데이터가 꼬여서 저장됨
수정 요청

저장 오류 발견

Admin/메뉴권한관리
저장은 정상적으로 동작하나 저장 클릭 시 오류창 발생 (ERROR CODE : 200 ....... Unexcepted end of JSON input)
확인 부탁드립니다.

네비게이션 싱크 확인

네비게이션
메뉴 권한 읽기, 쓰기 모두 없앤 후에도 좌측, 상단 상위 메뉴 화면에 표시됨(DATABASE관리는 표시됨)
확인 요청

링크 활성화 안됨

네비게이션
좌측 상단 메뉴 선택 시 서브 메뉴 중 기본 메뉴로 이동하거나, 링크가 아님을 표시.(손가락 커서로 변경x)

스케줄 수정 200에러

스케줄관리
하나의work가 있는 스케즐에 수정메뉴에서 다른 스케줄을 추가시 200 에러발생(수정후 수정버튼클릭시), 내용은 저장되어 있음.
확인 요청드립니다.

스케쥴 수정 오류

스케줄관리
스케줄 수정이 안됨. 목록에서 스케즐을 클릭시 수정페이지에서 정보표시가 안되고 계속 로딩이미지만 나옴.
(2개이상등록된 스케줄에서)

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.