1 of 13 – PostgreSQL – Instance Manager – Summary
2 of 13 – PostgreSQL – Instance Manager – Charsets
3 of 13 – PostgreSQL – Instance Manager – Collations
4 of 13 – PostgreSQL – Security Manager – Tree
5 of 13 – PostgreSQL – Security Manager – Users
6 of 13 – PostgreSQL – Security Manager – Groups
7 of 13 – PostgreSQL – Session Manager – Sessions
8 of 13 – PostgreSQL – Session Manager – Session Stats
9 of 13 – PostgreSQL – Session Manager – Locks
10 of 13 – PostgreSQL – Storage Manager – Tree
11 of 13 – PostgreSQL – Storage Manager – Tablespaces
12 of 13 – PostgreSQL – Storage Manager – Databases
13 of 13 – PostgreSQL – Storage Manager – Objects
PostgreSQL DBA Tools
Aqua Data Studio offers a suite of PostgreSQL DBA Tools for the monitoring, maintaining and tuning of the PostgreSQL server. It includes an Instance Manager, Storage Manager, Security Manager, and Session Manager. These managers allow the monitoring and maintenance of Tablespaces, Database Objects, Sessions, Users and Permissions via GUI.
Aqua Data Studio PostgreSQL Administration Tools Include:
PostgreSQL1 Instance Manager
Provides GUI view and search access for:
- Instance Summary (Server Component, Value, Group, Description, Extra Info, Context, Type, Source)
- Character Sets Parameters
- Collation
PostgreSQL Session Manager
Provides GUI view and search access for:
- Session Details, Kill Session
- Session Statistics
- Session Locks
- Session Grouping (By Process ID, Auth ID, and more)
PostgreSQL Storage Manager
Provides GUI view and search access for:
- Tree View for Tablespaces, Databases, Device Usage, Location
- Tablespace Properties and Details
- Properties of Databases, Device Usage, Default Tablespace, Location
- Table, Index Storage View
PostgreSQL Security Manager
Provides GUI view and search access for:
- Tree View for Users, Groups
- Users View, Create, Alter, Drop
- Groups View, Create, Alter, Drop
References
- ^ PostgreSQL Wikipedia article. PostgreSQL is an open source object-relational database management system (ORDBMS) developed by PostgreSQL Global Development Group.