eXperDB and PostgreSQL Management Tool
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.
- 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
- Supports PostgreSQL Version 12
- 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
- eXperDB-Management-Agent
- eXperDB-Management-WebConsole
- eXperDB-Management Repository Database
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-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
1. Installation eXperDB-Trnasfer(for Data Transfer)
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 (c) 2016-2020, eXperDB Development Team All rights reserved.