Database Management Interfaces
Symfoware Server provides tools to support database system construction. The tools are based on a set of programs that are installed along with Symfoware Server. The set of programs can be used to construct and operate databases.
Database construction - WebAdmin
WebAdmin – Can be used for creating, backing up, restoring, and managing instances:
Creating Instances
- Because resource settings are optimized automatically, WebAdmin allows simple instance creation by using only the minimum input necessary.
- When the WebAdmin settings are complete, the database is then ready for use.
Backing up and restoring instances
- WebAdmin can be used for executing backup and restore of instances individually.
Managing instances
- In WebAdmin, tasks for managing a database, such as recovery if a failure occurs and also monitoring the disk usage rate, can be operated intuitively using the GUI.
MonitoringTab
- Create an instance generation and database cluster.
- Delete the instance and cluster database.
- Start / Stop the instance.
- Backup the database cluster.
- Recover the database cluster.
- View error messages.
Settings Tab
- Set the locale and character code.
- Set the authentication information for the client to connect to the instance.
- Set up the communication definition applications and instances.
- Set the definition related to running a SQL statement.
- Set the memory usage.
pgAdmin
pgAdmin is a comprehensive design and management interface for PostgreSQL based databases. pgAdmin includes full Unicode support, fast, multithreaded query and data editing tools and support for all PostgreSQL object types. It includes a graphical administration interface, an SQL query tool and a procedural code editor.
pgAdmin can be used to write simple SQL queries or to develop complex databases. The graphical interface supports all PostgreSQL features and can be used to manage database instances.
pgAdmin can be used to perform database management tasks and maintenance operations:
- Create and manage databases.
- Create and manage users and roles.
- Manipulate tables (create tables, display data, and modify data) using data views.
- Execute SQL queries.
- Backup and restore databases.
- Create triggers.